| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help w/ macro to run user form
I have a problem with a macro that calls a user form. It
will not run in Module3. However, when I copy it to Module1, it works just fine. Sub ShowPiker() Piker.show endsub That will not run in Module3 but it works fine in Module1. Anybody have a clue why this would be the case? TIA GMet |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Help w/ macro to run user form
Typo?
endsub Must be end sub -- Regards Ron de Bruin http://www.rondebruin.nl "GMet" wrote in message ... I have a problem with a macro that calls a user form. It will not run in Module3. However, when I copy it to Module1, it works just fine. Sub ShowPiker() Piker.show endsub That will not run in Module3 but it works fine in Module1. Anybody have a clue why this would be the case? TIA GMet |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Help w/ macro to run user form
No typo. The original macro was in Module1. When I copy
and paste it into Module3 it does not work. When I take it back to Module1, it works. I am completely mystifed. GMet -----Original Message----- Typo? endsub Must be end sub -- Regards Ron de Bruin http://www.rondebruin.nl "GMet" wrote in message ... I have a problem with a macro that calls a user form. It will not run in Module3. However, when I copy it to Module1, it works just fine. Sub ShowPiker() Piker.show endsub That will not run in Module3 but it works fine in Module1. Anybody have a clue why this would be the case? TIA GMet . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| User Form activated by a macro | Excel Programming | |||
| help: master control macro and user form | Excel Programming | |||
| Copy from User form to Sheet macro | Excel Programming | |||
| I am looking to see if anybody has an equivalant user form to Outlooks CONTACT form | Excel Programming | |||
Linear Mode
