excel vba userforms: user-defined type not defined

Question

My Excel book contains a user form called myUserForm. I want to open it, fill it with data and programmatically press its buttons, but

Sub myUserFormShow()
 Dim muf As myUserForm
 muf.Show
End Sub

prompts an error User-defined type not defined. How to fix it? Thanks.

Why press the button programmatically? Will the user not click on the button? Please explain in detail as to what are you trying to achieve? — Siddharth Rout
– Siddharth Rout, Commented Feb 7, 2013 at 13:32

Peter L. · Accepted Answer · 2013-02-07 12:38:36Z

2

Use this code:

Sub myUserFormShow()
 myUserForm.Show
End Sub

answered Feb 7, 2013 at 12:38

Peter L.

7,3445 gold badges37 silver badges55 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Would you know why msdn.microsoft.com/en-us/library/office/… does not work in my case?

Have no even slightest idea buddy. Being QA I'd ask for: "please provide more details relevant to the issue")

Do you know how to clck buttons programmatically? myUserForm.myButton1.Run and myUserForm.myButton1.Click do not compile.