Thread
:
how do you set up a progress bar when running a macro in excel?
View Single Post
#
6
Posted to microsoft.public.excel.programming
Tushar Mehta
external usenet poster
Posts: 1,071
how do you set up a progress bar when running a macro in excel?
A lot safer than changing a cell's content would be to show the status
bar if appropriate.
Changing a cell requires (at a minimum) the following assumptions:
The cell is in the visible portion of a window.
That portion of the window is not obscured by another window
The cell is empty
Changing that cell will not trigger any other cascading changes
Changing the workbook's status to 'dirty' is acceptable
Neither the cell's row and column is hidden.
The cell's height and width are sufficiently large to show the progress
status
The cell's format (font size, color, pattern color, etc.) allow for a
visible progress status.
--
Regards,
Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
In article ,
says...
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?
Reply With Quote
Tushar Mehta
View Public Profile
Find all posts by Tushar Mehta