View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default Screen Updating For Status Bar

As long as you pick up the value of XXXX in a variable as your code loops
then try

Application.StatusBar = xxxx



Mike

"DownThePaint" wrote:

I have a VBA routine that keeps the user updated on progress by changing the
status bar (Processing xxx Row of yyyy). When the user multi tasks and goes
to do something else and then comes back to Excel the status bar updating is
frozen. I have the Application.ScreenUpdating set to TRUE.

Any Ideas?