Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie
Hi all,
Vanilla are planning an update to the site on April 24th (next Wednesday). It is a major PHP8 update which is expected to boost performance across the site. The site will be down from 7pm and it is expected to take about an hour to complete. We appreciate your patience during the update.
Thanks all.

excel and arrays

  • 04-07-2006 2:11pm
    #1
    Chaos
    Registered Users Posts: 1,134 ✭✭✭


    Anyone have anyidea on how to do this, I have an array in excel like below...
    .abcdefg
    1234567
    2345678
    3456789

    Now I have a drop down menu to make a choice from the x and y axis and I want the next box to return the value in the array....
    eg
    some selects a from first box then 2 from the next box then box 3 should populate with the answer 4.

    Any ideas?


Comments

  • #2
    Seth Brundle
    Moderators, Politics Moderators Posts: 38,773 Mod ✭✭✭✭Seth Brundle


    what about something like this... 
    Private Sub CommandButton1_Click() ' change to whatever!
    Dim arr(1 To 4) As String
    Dim x, y As Integer
    Dim returnItem As String
    
    arr(1) = ".abcdefg"
    arr(2) = "1234567"
    arr(3) = "2345678"
    arr(4) = "3456789"
    
    x = 2 'return the row - update to reflect value in your box
    y = 3 ' return the character from the chosen row - update to reflect value in your box

    returnItem = Mid(arr(x), y, 1)
    MsgBox (returnItem)

End Sub


Advertisement