Can anyone point me to sample code showing how lbXxxxxx_Change() is supposed to work?
I can't get code to jump to the sub when something in a listbox is changed.
Does ListBox on your form have the same name lbXxxxxx?
Thanks for the response.
Yes; same lbXxxxxx
_Click() works but _Change() doesn't ???
method Listbox_Change is called when the user selects one of the saved items. That is, you must first add any items to the ListBox.List collection
I'm afraid that in case of a listBox the difference between _Click and _Change in case of mouse clicking does not exist. They will fire the same.
If programmatically you will change selection, add new record, remove a line (you change something on the listBox) only _Change event will be triggered.
Here is a code example for you. Your form needs a single listbox named: ListBox1
Private Sub UserForm_Initialize()
Private Sub ListBox1_Change()