Showing a userform

  • Thread starter Thread starter Kent McPherson
  • Start date Start date
K

Kent McPherson

I have a userform defined. I have a bottom which makes the userform visible.
According to the book "Excel VBA Macro Programming" I should be able to make
it visible with this statement:

userform1.Show

But that didn't work. I had to change the statement to:

VBA.UserForms.Add("userform1").Show

Is that expected?
 
No, definitely not expected. Check your references: is the Microsoft Forms
Object Model checked? A userform is from MSForms, so I suspect the reason it
is not recognizing the UserForm as an object is that there is something wrong
with the MSForms library reference.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Userform 3
Question about modal userform..... 2
How to Show a userform from XLA sub 1
Code stops while Userform Shown 2
Userform is blank 4
Call random UserForm from list 10
keeping a userform visible 2
Bring my modeless userform to the foreground??? 8

Back
Top