Macro for Message Box
 

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.

Macro for Message Box
 

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.

Macro for Message Box
 

hi
stick with the user form. the built in vb msgbox doesn't not have a no
button setting and no timer that i am aware of. custom message boxes are
usually user forms.

Regards
FSt1

"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.