ComboBox Help
 

Is there a way to determine which element in the control array
selection is in a combobox? For instance, you have a list of student
and if you pick studen A it will tell you that student is number 50
out of 1000.

Thanks-
Chris Krah

--
cmk1
-----------------------------------------------------------------------
cmk18's Profile: http://www.excelforum.com/member.php...nfo&userid=604
View this thread: http://www.excelforum.com/showthread.php?threadid=39729

ComboBox Help
 

combobox1.ListIndex + 1

the first item is listindex zero, so add 1

combobox1.listcount gives the total number of items in the dropdown list

--
Regards,
Tom Ogilvy


"cmk18" wrote in
message ...

Is there a way to determine which element in the control array a
selection is in a combobox? For instance, you have a list of student,
and if you pick studen A it will tell you that student is number 500
out of 1000.

Thanks-
Chris Krahe


--
cmk18
------------------------------------------------------------------------
cmk18's Profile:
http://www.excelforum.com/member.php...fo&userid=6047
View this thread: http://www.excelforum.com/showthread...hreadid=397295