Very often when initialising or opening a userform, the debugger will show
the line that does the opening... the .Show line rather than where the
actual problem is. When it does you can continue to "step" through the code
to get to the actual line that is the the bugger in de code.

A word of warning though... when you try to execute the line it will take
you back to the start again! A bit like sliding down that snake but you
don't see the snake coming! It's a bit laborious but as you step through
line by line, set the code marker thingy to the next line you are going to
execute. That's the icon in the debugger that looks like a little blue
arrow. then you can go back to the offending place with a single click. As I
say.. laborious but it does stop the need to go through the code over and
over till you remember where the line is! Another way is ot print out the
code and mark it off line by line.