excel and arrays - boards.ie
Boards.ie uses cookies. By continuing to browse this site you are agreeing to our use of cookies. Click here to find out more x
Post Reply  
Thread Tools Search this Thread
04-07-2006, 14:11   #1
Registered User
Chaos's Avatar
Join Date: May 1999
Location: Maynooth
Posts: 1,117
Send a message via AIM to Chaos
excel and arrays

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

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....
some selects a from first box then 2 from the next box then box 3 should populate with the answer 4.

Any ideas?
Chaos is offline  
04-07-2006, 21:20   #2
Registered User
kbannon's Avatar
Join Date: Apr 2003
Location: The original home of Guinness!
Posts: 18,450
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
kbannon is offline  
Post Reply

Quick Reply
Remove Text Formatting

Insert Image
Wrap [QUOTE] tags around selected text
Decrease Size
Increase Size
Please sign up or log in to join the discussion

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Share Tweet