What is the equivalent of Workbook_Open() at the worksheet level, to trigger the launch of a MsgBox upon activating a worksheet?
What is the equivalent of Workbook_Open() at the worksheet level, to trigger the launch of a MsgBox upon activating a worksheet?
Worksheets actually have an Activate event.
I need the MsgBox to be displayed automatically when the worksheet is activated by the user
Well like I said use the worksheet Activate event.
Or the workbook's SheetActivate event.Private Sub Worksheet_Activate() MsgBox Me.Name End Sub
Private Sub Workbook_SheetActivate(ByVal Sh As Object) MsgBox Sh.Name End Sub
Isn't SheetActivate designed to activate a specified sheet from another location in the workbook? Is SheetActivate used in the sheet module or in a regular module?
Here's what I'm trying to accomplish: Let's say that Sheet1 I has a number of data fields. Upon clicking on the Sheet1 tab, I want a message box to pop up telling the user what he needs to do (I prefer this to adding individual cell comments).
Thanks for your help
Last edited by K. Georgiadis; 06-11-2005 at 07:05 AM. Reason: additional question
Hi Norie!
I put the code in the Sheet1 Module and confirmed that it works! Thanks again...marking this "Solved"