Can VBA make a bar which simulates the files opening?
Posted by Pls on June 11, 2000 10:35 PM
I need to show to the user that my program is still running when there's no apparent actions. I'll be very grateful if any VBA programmer can advise me on how to make a simple bar which shows the number of files left to be opened, similar to the one used in web browsers to show the time left to downloading.
Posted by Ryan on June 12, 0100 11:27 AM
You can use:
Application.StatusBar = "XXX"
This displays the information you want to give on excels status bar. At the end of your code, reset it using Application.StatusBar = "". Hope this helps
