Userform1.Show error

[PATSYS]

I have a userform, UserForm1.

In a module, I have the code:

Sub testform()
UserForm1.Show
End Sub

When I initially ran the testform sub, the userform shows which is fine.

However, the moment I make some changes to the userform (e.g. I added labels, textboxes, etc), I can not run the test form sub. I keep getting debug error and it points to the

UserForm1.Show

And when I click on reset button, it takes me to the userform1 - but al the changes I made were discarded althuogh I saved those changes before I ran the testform sub.

Why is this happening and what do I need to do save my changes and enable the sub to run?

Thanks

 

[RoryA]

If you get an error on that line, you probably have an error in the code in your userform. When you get the error, try pressing f8 to step through the userform code.

 

[PATSYS]

Hi Rory,

Thanks for your reply.

I do not have any code in my userform.

When I followed your advice (press F8) it only takes me back to the userform.

And all the changes I made were once again gone.

Is it not possible to make changes to userform?

Thanks

 

[RyanS]

It's possible that you have a reference error. Open tools, references and look at the checked items for one that has an error, and uncheck it.