Messge box

[Bill]

Hello everybody,

Does anyone know how can i work with message boxes?
there is anywy that i can make a message box to pop up
when someone hit on a cell?

Thanks a Lot
Bill

 

[Harald Staff]

Hi Bill

Rightclick the sheet tab, go "View Code", paste this in:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Address = "$B$1" Then
MsgBox "You are entering the great B1"
End If
End Sub

And to quote mrs Krabappel from The Simpsons: "Now that you know how to do
it, don't !" MsgBox'es are modal, you have to OK to get rid of them, few
people digest the message and they are in general very annoying.