Refering to 2nd Column in a Combobox
I have the BoundColumn =2
ColumnCount=2
And ALPHABET is on the LEFT SIde of the Combobox.
I still seem to get illogical numerical values in the other value in the msg.
Whe
ALPHABET SOUP
I get
ALPHABET 13
??
Using :
MsgBox & ComboBox2.Value & " " & ComboBox2.List(2, 0)
"merjet" wrote in message
oups.com...
Either of these should work:
1. MsgBox ComboBox2.Value & " " & ComboBox2.List(ListIndex, 1)
if BoundColumn = 1 and ALPHABET in selected row
2. MsgBox ComboBox2.List(2,0) & " " & ComboBox2.List(2, 1)
if ALPHABET in the 3rd row (2nd since counting starts with 0)
Merjet
|