Automatic launch of a MsgBox

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.

Code:

---

Private Sub Worksheet_Activate()
  MsgBox Me.Name
End Sub

---

Or the workbook's SheetActivate event.

Code:

---

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

Hi Norie!

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