LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,092
Default how do you set up a progress bar when running a macro in excel?

Not Everyone may have the status bar visible, so you might want to try
putting some text in a cell and then removing it -
Sheet1.Range("A2").Value = "Calculating...."
Application.ScreenUpdating = False
Some code
Sheet1.Range("A2").Value = ""
Application.ScreenUpdating = True

Mike F
"Don Guillett" wrote in message
...
statusbar="running"
code
statusbar=""

--
Don Guillett
SalesAid Software

"Neil Hopkinson" <Neil
wrote in
message
...
I have written a macro which takes a minute or so to run. I want to set
up

a
progress bar so the user can see something happening and knows the
program
hasn't crashed. How do I do this?





 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Progress Meter during macro execution Rob[_21_] Excel Programming 7 June 22nd 04 06:36 PM
Macro works in 2000 not XP for Progress Bar Far Excel Programming 0 May 19th 04 09:42 PM
Macro and slowing a progress bar. Rockee052[_18_] Excel Programming 3 January 26th 04 09:34 PM
Launch Macro in Access via Macro running in Excel??? dgrant Excel Programming 1 September 24th 03 01:38 PM
Running Excel Macro from VB6 Rick Griffith Excel Programming 2 August 13th 03 07:05 PM


All times are GMT +1. The time now is 02:01 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"