ListBox Click Event
xyz = Activesheet.ListBox1. Value
would put the selection into variable xyz for use in your code
"BHatMJ" wrote:
I have a listbox control on a user form in Excel. I want to add code
whenever an item in the listbox is selected/unselected. I assumed I could do
this in the "click" event of the list box. However, clicking on any of the
items in the listbox does not trigger the event. Can anyone help?
|