User Form activated by a macro
 

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

User Form activated by a macro
 

Try putting
Userform1.Show
in the macro

HTH. Best wishes Harald

"mxleite" skrev i melding
...
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

User Form activated by a macro
 

It worked just fine. Thanks a lot

"Harald Staff" wrote:

Try putting
Userform1.Show
in the macro

HTH. Best wishes Harald

"mxleite" skrev i melding
...
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

User Form activated by a macro
 

On Fri, 2 Jul 2004 13:51:01 -0700, "mxleite"
wrote:

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.

---------------------------------------------------------
Hank Scorpio
scorpionet who hates spam is at iprimus.com.au (You know what to do.)
* Please keep all replies in this Newsgroup. Thanks! *