View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Vasant Nanavati Vasant Nanavati is offline
external usenet poster
 
Posts: 1,080
Default Combobox Item Number

Hah ... beat you to it!

I must be feeling better ... :)

Regards,

Vasant.

"Harald Staff" wrote in message
...
Hi Todd

Combo1.ListIndex + 1

(since item 1 is listindex 0 )

HTH. Best wishes Harald

"Todd Huttenstine" skrev i melding
...
Lets say there are 20 items that can possible be chosen
out of a combobox. Lets say I selected the
value "April". The value April is the 4th item in the
combobox. What is the code that will return 4? I just
need a code that will return the location number of the
value that I selected.


Thank you
Todd Huttenstine