| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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! * |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| MACRO ACTIVATED AYTOMATICALLY | Excel Discussion (Misc queries) | |||
| How do I fill a cell in a user form from a selection on same form? | Excel Discussion (Misc queries) | |||
| MACRO ACTIVATED EVERY 5 SECONDS | Excel Discussion (Misc queries) | |||
| help: master control macro and user form | Excel Programming | |||
| Copy from User form to Sheet macro | Excel Programming | |||
Linear Mode
