Macro for Message Box

  • Thread starter Thread starter K
  • Start date Start date
K

K

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.
 
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
 
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
 
Back
Top