Thread
:
display userform for 10 seconds
View Single Post
#
8
Posted to microsoft.public.excel.programming
papou[_4_]
external usenet poster
Posts: 110
display userform for 10 seconds
Sandy
If the label already has text on it, and you want to change this text for
some time, then use the Repaint method:
Label1.Caption = ""For further information refer to bla bla"
UserForm1.Repaint
And use this method each time you change the label's text.
HTH
Cordially
Pascal
"Sandy" a écrit dans le message de news:
...
It is meant to simply display a message - "For further information refer
to bla bla" - for 10 seconds.
Sandy
"Orion Cochrane" wrote in
message ...
What does this userform do?
--
I am running on Excel 2003, unless otherwise stated. Please rate posts so
we
know when we have answered your questions. Thanks.
"Sandy" wrote:
Hi guys
Both work very well with the exception that the information on the
userform
(labels) does not display - any ideas why this should happen?
Sandy
"Sandy" wrote in message
...
Hi
I am trying to have a UserForm display for 10 seconds and then have
the
rest of my sub proceed.
have tried
********
frmPrime.Show
Application.Wait Now + TimeValue("00:00:10")
frmPrime.Hide
********
but this just stops the code permanently. Any ideas?
Sandy
Reply With Quote
papou[_4_]
View Public Profile
Find all posts by papou[_4_]