vba Userform 'onchange' not executing

[ccordner]

I have two userforms, one of which has a combobox listing names. Once a name is entered, it executes some code based on the value of the combobox. This is on the 'onchange' event.

If a name is entered which doesn't already appear in the list, a new userform is opened. But on this userform, none of the 'onchange' or 'afterupdate' events work.

They all work fine when the form is opened direct, just not when it is opened from a different form.

Any ideas why?

Chris.

 

[RoryA]

If you use the Exit event for the employees combo, then the combo on the second form autocompletes fine.