| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
SheetActivate event
I have a workbook that contains a number of sheets. I want
to be able to pop up a message box when a user selects a specific sheet. How do I do it? Thanks |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
SheetActivate event
Hi Andy
Put this in the worksheets module Private Sub Worksheet_Activate() MsgBox ("Your Message here....") End Sub -----Original Message----- I have a workbook that contains a number of sheets. I want to be able to pop up a message box when a user selects a specific sheet. How do I do it? Thanks . |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
SheetActivate event
Many thanks for that - it worked a treat :)
-----Original Message----- Hi Andy Put this in the worksheets module Private Sub Worksheet_Activate() MsgBox ("Your Message here....") End Sub -----Original Message----- I have a workbook that contains a number of sheets. I want to be able to pop up a message box when a user selects a specific sheet. How do I do it? Thanks . . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| event vba | Excel Worksheet Functions | |||
| VBA Event | Excel Discussion (Misc queries) | |||
| Event Procedures: Event on Worksheet to fire Event on another Worksheet | Excel Programming | |||
| change event/after update event?? | Excel Programming | |||
| OnTime event not firing in Workbook_Open event procedure | Excel Programming | |||
Hybrid Mode
