Advertisement
Help Keep Boards Alive. Support us by going ad free today. See here: https://subscriptions.boards.ie/.
If we do not hit our goal we will be forced to close the site.

Current status: https://keepboardsalive.com/

Annual subs are best for most impact. If you are still undecided on going Ad Free - you can also donate using the Paypal Donate option. All contribution helps. Thank you.
https://www.boards.ie/group/1878-subscribers-forum

Private Group for paid up members of Boards.ie. Join the club.

excel and arrays

  • 04-07-2006 02:11PM
    #1
    Chaos
    Registered Users, Registered Users 2 Posts: 1,136 ✭✭✭


    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, Paid Member Posts: 44,033 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