Automatically closing messages

[Vincent]

A ´problem´which continues to bug me: How do I create a message that after X
seconds/minutes/hours shuts itself, without the user having to click on
anything?

I know, well just about anyway, how this is done i Access, however whether
the same teqhnique is used in other VBA forms - I dont know.
I´m fairly certain there´s a differency, hence my writing.'

Please tell me I´m wrong, to stop creating problems where there aren´t any -
please...
--

 

[Cindy M -WordMVP-]

Hi =?Utf-8?B?VmluY2VudA==?=,

You'd need to use the OnTime method in order to call a procedure that will unload
the UserForm.

A ´problem´which continues to bug me: How do I create a message that after X
seconds/minutes/hours shuts itself, without the user having to click on
anything?

I know, well just about anyway, how this is done i Access, however whether
the same teqhnique is used in other VBA forms - I dont know.
I´m fairly certain there´s a differency, hence my writing.'

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail

 

[Karl E. Peterson]

A ´problem´which continues to bug me: How do I create a message
that after X seconds/minutes/hours shuts itself, without the user
having to click on anything?

Please see: http://vb.mvps.org/samples/MovedMsg

I know, well just about anyway, how this is done i Access, however
whether the same teqhnique is used in other VBA forms - I dont know.
I´m fairly certain there´s a differency, hence my writing.'

Please tell me I´m wrong, to stop creating problems where there
aren´t any - please...

Well, we all do that at times. I'm sure I created lots, for the sake of
experimentation, with the above sample. It could be that Cindy's suggestion will
work fine, as well? Same general idea, I believe, but this one's independent of
OnTimer, and tosses in a few "bonus" capabilities.