sVal1 = "": sVal2=""
With Combobox2
if .ListIndex < -1 then
sVal2 = .List(.ListIndex,1)
sVal1 = .List(.Listindex,0)
end if
End With

msgbox sVal1 & " " & sVal2

--
Regards,
Tom Ogilvy


"Corey" wrote in message
...
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