Thread: Listbox issues
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_6_] Bob Phillips[_6_] is offline
external usenet poster
 
Posts: 11,272
Default Listbox issues

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