You may very well get flamed for posting that attachment.

Without even looking at it .......

The click even on controls is triggered when the content of the
control changes - such things as changing the contents of a listbox
will trigger event.

Chrissy.


"John T Ingato" wrote in message ...
I am stumped. I have userform code that jumps to a Listbox_click function
when I update the form. I cannot figure out why is it being diverted there.
I did not direct it there

Please, See attached file if you have the time to look thru it. I had to
WinZip; it was too large.

Open the file Ctrl+Shift+S Runs the macro

The error occurs after I :

Switch to the Rep Info teb,
Click on any name in the 1st listbox,
Switch back to the setup page
Enter text and hit the add button.

It appears that in the "UpdateForm" routine, setting the
"ListOfRepsBox.Rowsource" property triggers a "ListOf RepsBox_click event.
Am I going insane.