Automatic launch of a MsgBox

[K. Georgiadis]

What is the equivalent of Workbook_Open() at the worksheet level, to trigger the launch of a MsgBox upon activating a worksheet?

[Norie]

Worksheets actually have an Activate event.

[K. Georgiadis]

I need the MsgBox to be displayed automatically when the worksheet is activated by the user

[Norie]

Well like I said use the worksheet Activate event.


Private Sub Worksheet_Activate()
MsgBox Me.Name
End Sub

Or the workbook's SheetActivate event.


Private Sub Workbook_SheetActivate(ByVal Sh As Object)
MsgBox Sh.Name
End Sub

[K. Georgiadis]

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

[K. Georgiadis]

Hi Norie!

I put the code in the Sheet1 Module and confirmed that it works! Thanks again...marking this "Solved"