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

Answering my own question.
Just ad 1,2,...,n in a column i the rowsource and hide the column by setting
the columnwidth property in listbox

Mark

"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