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 there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

excel and arrays

  • 04-07-2006 1:11pm
    #1
    Chaos
    Registered Users, Registered Users 2 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: 41,235 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