Showing a userform
 

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?

Showing a userform
 

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.
--
- K Dales


"Kent McPherson" wrote:

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?