User Form activated by a macro

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a design shape in a worksheet which when clicked runs a macro. This macro should call a user form. How would be code like for activating the user form?

Thanks
 
Try putting
Userform1.Show
in the macro

HTH. Best wishes Harald

mxleite said:
I have a design shape in a worksheet which when clicked runs a macro. This
Click to expand...
macro should call a user form. How would be code like for activating the
user form?
 
It worked just fine. Thanks a lot

Harald Staff said:
Try putting
Userform1.Show
in the macro

HTH. Best wishes Harald


macro should call a user form. How would be code like for activating the
user form?
Click to expand...
 
I have a design shape in a worksheet which when clicked runs a macro. This macro should call a user form. How would be code like for activating the user form?
Click to expand...

For example:

UserForm1.Show

Replace UserForm1 with whatever the form's real name is.
 
You must log in or register to reply here.

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

Shape Arrays VBA 0
Excel button problem 2
Finding the same unique identifier in multiple worksheets 2
Run Macro on All Sheets Q 8
Finding name of shape that was last clicked - Application.Caller 5
Access Automatically Send a notification email once a record is added 0
Disable user interaction in VBA 1
VBA Excel - Select a value from one cell in Excel to update a SQL table 1

Back
Top