If you mean
VB, you can use the listindex
i = Combo1.Listindex
One thing to note is that the listindex property is zero based, so i
you are looking for the fourth item in the list, it will have
listindex of 3.
Also, to get the value for an item where you know the listindex, yo
would use:
strValue = Combo1.List(1)
Which would retrieve the second value in your list.
K
Edit: Way too slow I see..
--
Message posted from
http://www.ExcelForum.com