StatusBar fails to update

G

Guest

I am using Office 2003 on Windows XP.

Since migrating to Office 2003, the "StatusBar" does not function as intended.
In previous versions, I routinely placed something like the following in my
code:

Application.StatusBar = "Downloading @: " & Format(Now(), "hh:mm am/pm"
<other code here>
Application.StatusBar = "Formatting..."
<other code here>
etc., etc.

This worked great since I could use the status bar as a pseudo progress
meter. I also use it to help me time my code to see where it's inefficient.

In Office 2003 however, the statusbar only updates the first time the code
is located. After that, it stays the same until the program is done. Does
anyone know why this happens and how I can force it to update whenever the
code line is encountered?

Thanks much in advance.
 
R

Ron de Bruin

Hi quartz

I test it in 2003 and it is working for me

Post a small test macro in this thread and I will test that also for you
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

TextBox vs. Label vs. StatusBar with displaying updates to user 3
issue running in Excel 2003, not in 97, error 9 subscript out of range 1
Row insert fails to update Sum formula 6
status update during program run -- DoEvents doesn't always work 2
Database update Mk II 3
Crteating Multiple GIFS from Multiple Ranges -- need someone to test my code to see why it fails 4
Which references am I missing, to call Outlook from Excel VBA? 4
Excel 2003 Pivot and VBA loop through each record to change cellbackground color based on conditions 0

Top