Thanks for taking the time to read my question.

Is there an OnTimer event in Excel, like there is in Access.

I have a form that I want to show for a few seconds when my Excel Workbook
opens. Just to show some general info like version, who make the workbook,
etc..

Timer in Excel doesn't seem to work the same way. The help file says it
helps calculate the time from midnight to now.

Thanks again.

Brad

Perhaps something like:

Private Sub UserForm_Activate()
Application.Wait Now + TimeValue("00:00:05")
Unload Me
End Sub

--

Vasant

"Brad" wrote in message
...
Thanks for taking the time to read my question.

Is there an OnTimer event in Excel, like there is in Access.

I have a form that I want to show for a few seconds when my Excel Workbook
opens. Just to show some general info like version, who make the
workbook,
etc..

Timer in Excel doesn't seem to work the same way. The help file says it
helps calculate the time from midnight to now.

Thanks again.

Brad

See Chip Pearson's page on the Ontime Function

http://www.cpearson.com/excel/ontime.htm

--
Regards,
Tom Ogilvy


"Brad" wrote in message
...
Thanks for taking the time to read my question.

Is there an OnTimer event in Excel, like there is in Access.

I have a form that I want to show for a few seconds when my Excel Workbook
opens. Just to show some general info like version, who make the
workbook,
etc..

Timer in Excel doesn't seem to work the same way. The help file says it
helps calculate the time from midnight to now.

Thanks again.

Brad

That Worked Perfectly!!! And the fact that the user can't do anything is ok
in my case too.

Thanks!

Brad

"Vasant Nanavati" wrote:

Perhaps something like:

Private Sub UserForm_Activate()
Application.Wait Now + TimeValue("00:00:05")
Unload Me
End Sub

--

Vasant

"Brad" wrote in message
...
Thanks for taking the time to read my question.

Is there an OnTimer event in Excel, like there is in Access.

I have a form that I want to show for a few seconds when my Excel Workbook
opens. Just to show some general info like version, who make the
workbook,
etc..

Timer in Excel doesn't seem to work the same way. The help file says it
helps calculate the time from midnight to now.

Thanks again.

Brad