I have a simple app - one userform that I call from a command button on the
spreadsheet.
A couple of times - I run into an error message when trying to show the
userform. Either a subscript out of range (I am not using subscripts) or a
type mismatch error.
I try renaming the form - no good. I try loading it then showing it - still
no good.

I got the following off of the website here - I named the form UserForm1
(very original I admit) - as soon as it gets to the load UserForm1 I get the
subscript error. I have used other names - renamed the form - nothing works.

I have run into this a couple of times before - Excel gets into a funk and
will not recognize the form. The funny thing is that the code will work
during the early stages of development - then I add a few more items to the
form and it gets into this run time error thing.

The MS website info addresses collections of userforms and getting this
error - but I have only a single form I am trying to display.

Any help is greatly appreciated - I tried all 3 of the "workarounds" as
suggested on the MS website and none of them worked.