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

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?

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?

For some mindless fun , try this link.

http://pubs.logicalexpressions.com/P...cle.asp?ID=407

Cheers,
--
Tausif Mohammed


"MillyD" wrote:

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?