I know this thread is ancient, but I stumbled upon it while looking for a solution to the same problem. What I discovered was that I had a combobox with the enter event running code that was triggering first instead of the userform activate event and the activate event never triggered. This was occurring because the offending combobox was first in the userform tab order and when the form showed, it ran immediately. Moving the combobox down in the tab order solved the problem and allowed the activate event to run as it should. It seems like the activate event should take precedence but apparently it doesn't.