Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
TIMED MSGBOX
What macro should be assigned to a message box to pop up upon opening a
workbook displaying company logo and disappearing in 2 seconds? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
TIMED MSGBOX
Faraz,
I would use a customized userform and use the onTime method to make it dissapear. -- http://HelpExcel.com "FARAZ QURESHI" wrote: What macro should be assigned to a message box to pop up upon opening a workbook displaying company logo and disappearing in 2 seconds? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
TIMED MSGBOX
Thanx Galimi,
But can u write a line of example to provide me correct syntax of onTime method? "FARAZ QURESHI" wrote: What macro should be assigned to a message box to pop up upon opening a workbook displaying company logo and disappearing in 2 seconds? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
TIMED MSGBOX
application.ontime now + timevalue("00:00:02"),,"closeForm"
The closeForm sub would then close the userform... sub closeForm userform1.hide end sub -- http://HelpExcel.com "FARAZ QURESHI" wrote: Thanx Galimi, But can u write a line of example to provide me correct syntax of onTime method? "FARAZ QURESHI" wrote: What macro should be assigned to a message box to pop up upon opening a workbook displaying company logo and disappearing in 2 seconds? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
TIMED MSGBOX
FARAZ
For more on the OnTime method see Chip Pearson's site. http://www.cpearson.com/excel/ontime.htm Soon you will be writing your own "lines" Gord Dibben MS Excel MVP On Tue, 2 Jan 2007 11:24:01 -0800, FARAZ QURESHI wrote: Thanx Galimi, But can u write a line of example to provide me correct syntax of onTime method? "FARAZ QURESHI" wrote: What macro should be assigned to a message box to pop up upon opening a workbook displaying company logo and disappearing in 2 seconds? |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
TIMED MSGBOX
THANX GORD YOU'RE GREAT
"FARAZ QURESHI" wrote: What macro should be assigned to a message box to pop up upon opening a workbook displaying company logo and disappearing in 2 seconds? |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
TIMED MSGBOX
Just a heads up, have you thought about that you might "over" design
your workbook. I for one would find it very annoying to get macro warnings and then have to look at a logo and what have you every time I open a particular workbook. I would turn it off which is very easy by either go in and remove the macro or not allow macros to run at all. Regards, Peo Sjoblom FARAZ QURESHI wrote: THANX GORD YOU'RE GREAT "FARAZ QURESHI" wrote: What macro should be assigned to a message box to pop up upon opening a workbook displaying company logo and disappearing in 2 seconds? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hiding, or automatically answering, a confirmation msgbox | Excel Discussion (Misc queries) | |||
msgbox | Excel Discussion (Misc queries) | |||
Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
MsgBox compile error in Excell | Excel Discussion (Misc queries) | |||
Msgbox | Excel Worksheet Functions |