Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
click in a workbook
Hello,
I would like to create controls on different sheet. But have the event code in the main workbook. And have none in the worksheets. Is this possible? Where I could have a Workbook_<SOMETHING event. Then have a case statment looking for the control name. If it was CommandButton1 on sheet1 I would look for CommandButton1. If it was CheckBox1 on sheet5, I would look for CheckBox1. is this possible? thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
click in a workbook
I thought I could use the WithEvents
so in my workbook have Private WithEvents CmdBut As CommandButton then Private Sub CmdBut_Click() MsgBox "in thisworkbook" End Sub but this does not work Any help? thanks "greg" wrote in message ... Hello, I would like to create controls on different sheet. But have the event code in the main workbook. And have none in the worksheets. Is this possible? Where I could have a Workbook_<SOMETHING event. Then have a case statment looking for the control name. If it was CommandButton1 on sheet1 I would look for CommandButton1. If it was CheckBox1 on sheet5, I would look for CheckBox1. is this possible? thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I toggle between sheets in a workbook without having to click? | Excel Discussion (Misc queries) | |||
Click on cell to open another workbook | Excel Discussion (Misc queries) | |||
can't click on cell to reference to another workbook | Excel Worksheet Functions | |||
Double Click will not open my Workbook | Excel Discussion (Misc queries) | |||
Overwriting an existing workbook without having to click yes in the prompt box | Excel Programming |