Display MsgBox when selecting a sheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a way that I can have a message box display whenever a particular
sheet is selected?

Thanks,
~ Horatio
 
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
 
Right click on the sheet tad where you want this to happen and select
View Code. Then paste in the code below. Modify the message box as
needed.
Private Sub Worksheet_Activate()
MsgBox "your stuff here!"
End Sub
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

MsgBox line break 1
Use cell contents to build sheet reference 5
Compatibility Checker - minor loss of fidelity 2
Excel [VBA] Check from a cell into another sheet and bring back result in MsgBox 0
MsgBox from another sheet 6
UserForm OptionButtons 3
Prevent deleting multiple cells at once 2
Excel Providing user message when RED X clicked & properly closing application. 2

Back
Top