View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.programming
papou[_4_] papou[_4_] is offline
external usenet poster
 
Posts: 110
Default 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