View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Ardus Petus Ardus Petus is offline
external usenet poster
 
Posts: 718
Default HELP!!!! needed in Excel

Try the .Topindex property of Combobox

HTH
--
AP

"Ivan Raiminius" a écrit dans le message de
news: ...
Hi,

try using match function:

=match(data value,original list used to fill combobox,0) should give
you the index you are looking for (in case first index was 0, substract
1 from match result)

Regards,
Ivan