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
Chaos
Registered User
 
Chaos's Avatar
 
Join Date: May 1999
Posts: 1,105
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...
.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?
Chaos is offline  
Advertisement
04-07-2006, 21:20   #2
kbannon
Registered User
 
kbannon's Avatar
 
Join Date: Apr 2003
Location: The original home of Guinness!
Posts: 17,559
what about something like this...
Code:
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
Message:
Remove Text Formatting
Bold
Italic
Underline

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