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

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