PDA

View Full Version : [SOLVED] Automatic launch of a MsgBox



K. Georgiadis
06-11-2005, 05:47 AM
What is the equivalent of Workbook_Open() at the worksheet level, to trigger the launch of a MsgBox upon activating a worksheet?

Norie
06-11-2005, 05:57 AM
Worksheets actually have an Activate event.

K. Georgiadis
06-11-2005, 06:13 AM
I need the MsgBox to be displayed automatically when the worksheet is activated by the user

Norie
06-11-2005, 06:28 AM
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
06-11-2005, 07:03 AM
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
06-11-2005, 07:12 AM
Hi Norie!

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