In trying to solve a problem with a user form, I began to suspect that
multiple subs were being triggered as soon as I showed the form. I put
a MsgBox into each sub in the code section of my userform, except for
Userform_Initialize. The form has two multicolumn list boxes, two combo
boxes, and three command buttons. Both listboxes and one combobox have
change event subs. When I initially call up this userform (from a
button in a Worksheet) the message box in the combobox change event sub
appears once, the message box in one listbox appears twice, and the
other appears three times! Is this normal behavior? Could this be why
my listbox selection values are being cleared unexpectedly?
I would really appreciate any help on this matter.