status bar

[Patrick Alexander]

Hi
what command do i use to give a status of a macro in the status bar
I want to indicate in the status bar what we are doing, how can i put a certain status in it.

regards
Patrick

 

[Smitty]

You can control it directly with:

Application.StatusBar = "5% Complete"

Just set it to False at the end.

Or check out John Walkenbach's Control the LED Display in the StatusBar.

HTH,

Smitty

 

[Artemus]

Use the following command to post text on the status bar.

Application.StatusBar = "Your message here."