OnTimer Event

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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
> news:[email protected]...
> > 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
>
>
>