Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro Message Bar | Excel Discussion (Misc queries) | |||
Macro message box. | Excel Discussion (Misc queries) | |||
Enable macro message on VBA Workbook Open then macro ends | Excel Programming | |||
A macro disabled message comes up but there is no macro. | Excel Discussion (Misc queries) | |||
Macro message box | Excel Discussion (Misc queries) |