Thread: Listbox issues
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Mark[_36_] Mark[_36_] is offline
external usenet poster
 
Posts: 39
Default Listbox issues

Thanks thats it!!

"Bob Phillips" wrote in message
...
Mark,

Have you looked at the ListIndex property?

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Mark" wrote in message

...
Hi NG

I have populated a listbox by using listbox1.rowsource
There are many similar entries in the listbox.

The user can then an entry and the listbox_change() callback is called.

In
this callback I would like to be able to extract the rownumber of the

users
selection e.g. rownumber == 3 if the user chooses row 3 in the listbox.

The
reason that I do not use Listbox.value is as i mentioned before the many
similar entries in the listbox.

Regards
Mark