| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to click the button from module?
Thank you
"Harald Staff" wrote: Sub Demo() Call UserForm1.CommandButton1_Click End Sub HTH. Best wishes Harald "OKLover" skrev i melding ... What if the commandbutton is on the userform? how to call it? "Tom Ogilvy" wrote: If you make it public instead of private Public Sub CommandButton1_Click() end Sub then in another module you can do Sheet1!CommandButton1_Click Where sheet1 is the code name of the sheet containing the code. -- Regards, Tom Ogilvy "OKLover" wrote in message ... Hi, all Does it possible to click the commandbutton(or activate the commandbutton_click event) on the userform from the global module? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Assigning a module to a button macro | Excel Discussion (Misc queries) | |||
| command button for vba module | Excel Programming | |||
| On Button Click(Help!) | Excel Programming | |||
| Adding module - assigning macro to button | Excel Programming | |||
| Attaching a macro (module) code to button | Excel Programming | |||
![OKLover[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
