Information Box

[DR]

How do I put an information box on an excel worksheet which pops up everytime

 

[Tausif]

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

 

[MillyD]

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

Do you know any more useful code like that one

 

[Tausif]

For some mindless fun , try this link.

http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=407

Cheers,