ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   display userrform label for x seconds (https://www.excelbanter.com/excel-programming/371297-display-userrform-label-x-seconds.html)

Gary Keramidas

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




Dave Peterson

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

Gary Keramidas

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




Dave Peterson

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


All times are GMT +1. The time now is 02:01 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com