I'm using a label as a "status bar" in my code, but the label's captio
is not changing on the user form until the very end. What this cod
does is, goes through approx 300 people and comes up with a list of wh
is on leave from work that day... the caption is supposed to tell yo
what name it is on and percentage complete, but won't change. I trie
using SetFocus on the label, but was getting an error. Any help
:confused

--
Brian Hribe
-----------------------------------------------------------------------
Brian Hribek's Profile: http://www.excelforum.com/member.php...fo&userid=1519
View this thread: http://www.excelforum.com/showthread.php?threadid=26827

Use this

Me.Repaint


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Brian Hribek" wrote in message ...

I'm using a label as a "status bar" in my code, but the label's caption
is not changing on the user form until the very end. What this code
does is, goes through approx 300 people and comes up with a list of who
is on leave from work that day... the caption is supposed to tell you
what name it is on and percentage complete, but won't change. I tried
using SetFocus on the label, but was getting an error. Any help?



--
Brian Hribek
------------------------------------------------------------------------
Brian Hribek's Profile: http://www.excelforum.com/member.php...o&userid=15196
View this thread: http://www.excelforum.com/showthread...hreadid=268279