StatusBar fails to update
 

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.

StatusBar fails to update
 

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


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


"quartz" wrote in message ...
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.

StatusBar fails to update
 

Ron,

Thanks, but I'm sorry, it will have to be tomorrow...

"Ron de Bruin" wrote:

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


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


"quartz" wrote in message ...
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.

StatusBar fails to update
 

Quartz,

Have you tried putting a DoEvents statement after your statusbar statements?

Robin Hammond
www.enhanceddatasystems.com

"quartz" wrote in message
...
Ron,

Thanks, but I'm sorry, it will have to be tomorrow...

"Ron de Bruin" wrote:

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


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


"quartz" wrote in message
...
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.