CODEWITHSUNDEEP
vbaexcellistboxuserform
Tibo
Tibo

Reputation: 393

VBA : getting Listbox selected column

I need the column equivalent of n = Me.ListBox1.ListIndex to find which column was selected by the user from a multicolumn ListBox.

Something like c = Me.ListBox1.SelectedColumn.

Does that exist ?

Upvotes: 0

Views: 882

Answers (1)

braX
braX

Reputation: 11755

There is no simple way of doing this, but with some effort you can make something work using the MouseDown event of the listbox, as that event includes the X co-ordinate of where the user clicked.

Upvotes: 2

Related Questions