User Form activated by a macro

M

mxleite

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
 
H

Harald Staff

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
macro should call a user form. How would be code like for activating the
user form?
 
M

mxleite

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?
 
H

Hank Scorpio

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?

For example:

UserForm1.Show

Replace UserForm1 with whatever the form's real name is.
 
Top