Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,494
Default display userrform label for x seconds

how could i do this ? i tried and if i stepped through the code, the label would
show, but if i ran the code, the label never displayed even though i could see
the timer running in the immediate window. i deleted what i had.


--


Gary



  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 35,218
Default display userrform label for x seconds

Try adding DoEvents or me.repaint (or both).

Gary Keramidas wrote:

how could i do this ? i tried and if i stepped through the code, the label would
show, but if i ran the code, the label never displayed even though i could see
the timer running in the immediate window. i deleted what i had.

--

Gary


--

Dave Peterson
  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,494
Default display userrform label for x seconds

i just ended up making it visible until another control was clicked


thanks
--


Gary


"Dave Peterson" wrote in message
...
Try adding DoEvents or me.repaint (or both).

Gary Keramidas wrote:

how could i do this ? i tried and if i stepped through the code, the label
would
show, but if i ran the code, the label never displayed even though i could
see
the timer running in the immediate window. i deleted what i had.

--

Gary


--

Dave Peterson



  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 35,218
Default display userrform label for x seconds

Seems like a reasonable approach.

As a user, I'd hate to see a message flash, then disappear before I could read
it.



Gary Keramidas wrote:

i just ended up making it visible until another control was clicked

thanks
--

Gary

"Dave Peterson" wrote in message
...
Try adding DoEvents or me.repaint (or both).

Gary Keramidas wrote:

how could i do this ? i tried and if i stepped through the code, the label
would
show, but if i ran the code, the label never displayed even though i could
see
the timer running in the immediate window. i deleted what i had.

--

Gary


--

Dave Peterson


--

Dave Peterson
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Display Seconds when inserting time in cells jane93 Excel Discussion (Misc queries) 4 October 19th 07 02:05 AM
How to display seconds on time stamp? uosam Excel Worksheet Functions 1 February 28th 06 09:05 PM
display no seconds in time format [h] Finolac Excel Discussion (Misc queries) 1 October 3rd 05 03:19 PM
display minutes and seconds in excel Jonathan Blundell Excel Worksheet Functions 1 September 10th 05 01:26 PM
How do I get a cell to display degrees, minutes, seconds? Bill Excel Worksheet Functions 2 December 22nd 04 12:13 PM


All times are GMT +1. The time now is 03:53 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"