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?