Reference a ListIndex value in a macro

[nigelog]

Im trying to reference the list index value of a listbox "DDlst_1" and the value is list index number 93, Ive tried various methods but cant nail it down

Please Login or Register  to view this content.

Also tried

Please Login or Register  to view this content.

any pointers appreciated

[xlnitwit]

ListIndex returns the index of the selected item, not its value, therefore you must use

Please Login or Register  to view this content.

If the data is not in the bound column, you should specify the column you want (which is also a 0 based index) as well.

[nigelog]

Please Login or Register  to view this content.

is spot on. Thanks xlnitwit