macro lauching user form

[ABC]

How can I launch a user form from a maco?

I tried formname.Show and that doesn't work.

Thanks

ABC

 

[greg mansius [MSFT]]

Which version of Excel?

Please try this test.

1. New workbook.
2. ALT+F11
3. Insert a userform with a label control.
4. New module.
5. Insert the following text into the module.

Sub Test()
UserForm1.Show
End Sub

6. Run the Test macro.

What happens? If this works, how is this test different from your scenario?

Thanks,

 

[ABC]

Actually that does work for me. I had a problem inside the form
that's why it wasn't displaying.....Sorry for wasting your time.

Thanks

ABC

Which version of Excel?

Please try this test.

1. New workbook.
2. ALT+F11
3. Insert a userform with a label control.
4. New module.
5. Insert the following text into the module.

Sub Test()
UserForm1.Show
End Sub

6. Run the Test macro.

What happens? If this works, how is this test different from your scenario?

Thanks,

--
Greg Mansius [MSFT]

This posting is provided "AS IS" with no warranties, and confers no rights.

How can I launch a user form from a maco?

I tried formname.Show and that doesn't work.

Thanks

ABC