Can VBA put anything in the status bar?

  • Thread starter Thread starter Top Spin
  • Start date Start date
T

Top Spin

Is there a way for a VBA macro to put anything in the status bar?

If not, is there a way for a macro to display progress information
that does not require the user to gtake any action to clear it?

I know that I can use a message box, but the user must do something
(Enter, Esc) to get rid of it. I wold like to be able to put status or
progress information somewhere that the user can check if they want to
or ignore.

Thanks

--
Running Word 2K SP-3 (9.0.6926)
PC: HP Omnibook 6000
OS: Win 2K SP-4 (5.00.2195)
Email: Usenet-20031220 at spamex.com
(11/03/04)
 
Check out the StatusBar command. For example:

StatusBar = "Hello world"

puts "Hello world" on the status bar.
 
Check out the StatusBar command. For example:

StatusBar = "Hello world"

puts "Hello world" on the status bar.
Click to expand...

Excellent. I should have tried "statusbar" in the VBA help file. I see
it now.

Thanks

--
Running Word 2K SP-3 (9.0.6926)
PC: HP Omnibook 6000
OS: Win 2K SP-4 (5.00.2195)
Email: Usenet-20031220 at spamex.com
(11/03/04)
 
The trouble with this is that as soon as Word writes its own message to the
bar (e..g finding....) it takes precedence over what you write to the bar
with VBA, so you may have to write code to periodically update the bar with
your text.

I while ago, I asked the group if it was possible to disable Word's own
status bar messages and nobody replied, so I guess it isn't.

Adrian
 
Hi Adrian,

Just to confirm... it isn't possible to prevent Word from overwriting
your text on the status bar. There is a way, using Windows API calls,
to freeze the entire window -- but then you can't write your own text
to the status bar either.
 
The trouble with this is that as soon as Word writes its own message to the
bar (e..g finding....) it takes precedence over what you write to the bar
with VBA, so you may have to write code to periodically update the bar with
your text.
Click to expand...

Actually, I consider this a benefit -- not a trouble. I just want to
put up a completion message. If the user (me) wants to look at it,
they better do it before they do anything else. Even moving the curser
causes the document status info to be redisplayed. Just what I wanted.
I while ago, I asked the group if it was possible to disable Word's own
status bar messages and nobody replied, so I guess it isn't.

Adrian
Click to expand...


--
Running Word 2K SP-3 (9.0.6926)
PC: HP Omnibook 6000
OS: Win 2K SP-4 (5.00.2195)
Email: Usenet-20031220 at spamex.com
(11/03/04)
 
Top Spin shared this with us in microsoft.public.word.newusers:
Is there a way for a VBA macro to put anything in the status bar?

If not, is there a way for a macro to display progress information
that does not require the user to gtake any action to clear it?

I know that I can use a message box, but the user must do something
(Enter, Esc) to get rid of it. I wold like to be able to put status or
progress information somewhere that the user can check if they want to
or ignore.
Click to expand...

John Walkenbach runs a site on Excel (http://www.j-walk.com/excel iirc)
with a lot of interesting VBA code that can also be used in Word.
There is a link to a very interesting progress indicator in the status
bar. I don't remember the exact page and I'm too lazy to look ;-) but
it should be easy enough to find.
 
Back
Top