macro lauching user form

  • Thread starter Thread starter ABC
  • Start date Start date
A

ABC

How can I launch a user form from a maco?

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

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,
 
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.

ABC said:
How can I launch a user form from a maco?

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

Thanks

ABC
Click to expand...
Click to expand...
 
Back
Top