Thread: Information Box
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
MillyD MillyD is offline
external usenet poster
 
Posts: 24
Default Information Box

Going to have some fun with that........

Do you know any more useful code like that one

"Tausif" wrote in message
...
Hi,

1)Open the WorkBook in Excel
2) Press Alt+F11 (which should open the visual basic editor)
3) In the project explorer(Ctrl+R), Double Click the worksheet where you
want the pop up to appear
4) Copy paste the code below

Private Sub Worksheet_Activate()
MsgBox "You can enter what you want to appear in the popup here."
End Sub

HTH
--
Tausif Mohammed


"DR" wrote:

How do I put an information box on an excel worksheet which pops up
everytime
someone selects that worksheet?