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?

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?

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?

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?

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?

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?

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?