Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Thanks. It works great.
I was trying to use Workbook_SheetChange, but then I got the message for all sheets, and I didn't know how to isolate the single sheet. ~ Horatio "Mike H" wrote: Horatio, Right click the sheet tab, view code and paste this in Private Sub Worksheet_Activate() msg = "You activated " MsgBox msg & ActiveSheet.Name End Sub Mike "Horatio J. Bilge, Jr." wrote: Is there a way that I can have a message box display whenever a particular sheet is selected? Thanks, ~ Horatio |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Macro display Msgbox when cells are empty | Excel Discussion (Misc queries) | |||
How to display remaining txt file which overflowed MsgBox display? | Excel Discussion (Misc queries) | |||
VB evaluate a value in a table's column and display msgbox | Excel Discussion (Misc queries) | |||
display cell value in msgbox formatted as % | Excel Discussion (Misc queries) | |||
Excel workbook fails to display when selecting from my documents. | Excel Worksheet Functions |