Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Displaying data on Excel Statusbar?
Hello,
Does Excel have any function like the SysCmd function in MS Access for displaying data in the Excel Statusbar? Is it possible to display data in the Excel statusbar or make like a progres meter? How to do this? Thanks, Rich |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Displaying data on Excel Statusbar?
On 17 apr, 20:18, Rich wrote:
Hello, Does Excel have any function like the SysCmd function in MS Access for displaying data in the Excel Statusbar? Is it possible to display data in the Excel statusbar or make like a progres meter? How to do this? Thanks, Rich Use (in VB) Application.Statusbar = "My message" to display a message and Application.Statusbar = False to remove it. To make a progressbar you can work with something like "Processing XXoooooo" to "Processing XXXXXXXX" DQ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Displaying data on Excel Statusbar?
Use the following:
Application.Statusbar = FALSE 'to turn off' Application.Statusbar = "Enter your comment" 'to display at the Lower Left corner of the Excel window. "Rich" wrote: Hello, Does Excel have any function like the SysCmd function in MS Access for displaying data in the Excel Statusbar? Is it possible to display data in the Excel statusbar or make like a progres meter? How to do this? Thanks, Rich |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Displaying data on Excel Statusbar?
Thank you all for your replies
"Rich" wrote: Hello, Does Excel have any function like the SysCmd function in MS Access for displaying data in the Excel Statusbar? Is it possible to display data in the Excel statusbar or make like a progres meter? How to do this? Thanks, Rich |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Displaying data on Excel Statusbar?
Check out VBE help on Application.StatusBar
For a progress bar on status bar see David McRitchie's site http://www.mvps.org/dmcritchie/excel/statusbar.htm For a userform see John Walkenbach's site. http://www.j-walk.com/ss/excel/tips/tip34.htm Gord Dibben MS Excel MVP On Tue, 17 Apr 2007 11:18:04 -0700, Rich wrote: Hello, Does Excel have any function like the SysCmd function in MS Access for displaying data in the Excel Statusbar? Is it possible to display data in the Excel statusbar or make like a progres meter? How to do this? Thanks, Rich |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Displaying data on Excel Statusbar?
"Gord Dibben" wrote: For a progress bar on status bar see David McRitchie's site http://www.mvps.org/dmcritchie/excel/statusbar.htm Gord Dibben MS Excel MVP Oh, man! This is so cool! I've got a procedure that takes about 8 minutes with screen-updating turned off. People are looking at me like it's frozen. So, I put in the progress bar - and now they are happy again! Sweet! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I get excel to load data from a multiple sheet displaying | Excel Discussion (Misc queries) | |||
FIX in Statusbar | Excel Discussion (Misc queries) | |||
Wall Mounted LCD displaying Excel Data? | Excel Discussion (Misc queries) | |||
Displaying Excel data in flattened hierarchy | Excel Worksheet Functions | |||
Statusbar | Excel Programming |