Solved

Displaying a message in taskbar that a macro is running.

Posted on 2014-01-29
2
329 Views
Last Modified: 2014-01-29
I used to do this in the old equals code...  how do I do this in the VBA world.  I would like it to say  "Macro running, please wait"  then when it is done remove it.   -R-
0
Comment
Question by:RWayneH
2 Comments
 
LVL 33

Accepted Solution

by:
Rob Henson earned 500 total points
ID: 39818210
At the start of the macro:

Application.StatusBar = "Macro Running"

At the end of the macro:

Application.StatusBar = False

Thanks
Rob H
0
 

Author Closing Comment

by:RWayneH
ID: 39818476
Thanks. -R-
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Since upgrading to Office 2013 or higher installing the Smart Indenter addin will fail. This article will explain how to install it so it will work regardless of the Office version installed.
Having trouble getting your hands on Dynamics 365 Field Service or Project Service trial? Worry No More!!!
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

791 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question