ActiveX Listbox events do not fire
Posted on 2011-02-16
I've got a form in an Excel VBA program that contains listboxes displaying user selections. When these listboxes are emptied, I want to disable a commandbutton on the form to prevent the user from continuing without having selected an item. Correspondingly, I want to enable this commandbutton as soon as something is written to the listbox again. All adding/deleting of items in the listbox is handled by the code.
I thought this was easy to achieve using events, but neither the listbox_change event nor the listbox_afterupdate event fires when an item is added to or removed from the listbox. Why not? What kind of event should I use?