Try putting a DoEvents in before the End

Not saying it will work but it's worth a shot.

DoEvents clears all waiting Events before going on...

Let us know if it works.

"End" will end  everything. What are you actually wanting to end?

"End If" needs the keyword "If"

"Exit Sub" or "Exit Function" to exit a sub or a function

etc.

Post more of the code  and tell us what is actually supposed to happen where
you have your "End" statement.

Also, have you compiled the project to make sure it has no syntax errors in
it?

The code  runs fine and at the end  I do want to end everything. However
I would like the userform  to load  before the code ends. That is the
only real problem. Also, I have run the code a few times. It works
great except the form no longer loading. (It loaded before I used the
end function and just put a break in the code manually.)

AFAIK, "end" ends everything, including user forms. So the form is probably
loading, and then getting "ended".

You don't want to "end" until you are really finished (i.e. about to close
the workbook). In fact, you shouldn't even want to do it then. Only use
"end" as an "emergency shutdown" if there is a fatal error, and processing
must not continue.

Just return from whatever subroutines you are in (using Exit Sub if you
can't just return normally). The form will then be left showing and VBA
will be waiting for the next user event.

BTW I don't know what you're expecting to do with a form called pauseform,
but I suspect you won't achieve it. Excel programs are event-driven and
there is no concept such as a "pause".