try this: right click on the sheet you want this to occur on, and
choose "view code". enter this code:

Option Explicit

Private Sub Worksheet_Change(ByVal Target As Range)

If Target.Address = "$B$1" Then
MsgBox "Hello there"
End If

End Sub

this should give you an idea of how to proceed.
write back if you have questions.
:)
susan



On Aug 12, 8:41*am, K wrote:
Hi all, Is there way to display Message box without any button on it
for few seconds and then make it disappear automatically. *I know I
can achive this by Userform but I need do this with any other way than
using Userform. *Has any friend got any idea.