Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how do you set up a progress bar when running a macro in excel?
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
how do you set up a progress bar when running a macro in excel?
I was about to ask almost the same question (and this was the top post)
I want to display some type of message as the macro starts... then when its done, have the message go away. something like "Please wait, Macro running". The progress indicator would be nice to have as well... "Neil Hopkinson" wrote: 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? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
how do you set up a progress bar when running a macro in excel?
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? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
how do you set up a progress bar when running a macro in excel?
For a few different options see
http://www.mrexcel.com/board2/viewto...?p=88129#88129 -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions In article , "=? Utf-8?B?TmVpbCBIb3BraW5zb24=?=" <Neil says... 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? |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
how do you set up a progress bar when running a macro in excel?
Hi Neil,
a few more site that might be helpfull: http://j-walk.com/ss/excel/tips/tip34.htm http://www.dicks-blog.com/archives/2.../progress-bar/ a nice example: http://www.oaltd.co.uk/DLCount/DLCou...e=WksPrgrs.zip hope u can use this!! "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? |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
how do you set up a progress bar when running a macro in excel
Thankyou to everyone for your help. Much Appreciated
|
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
how do you set up a progress bar when running a macro in excel?
"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? You have to use the CreateWindowEx API function if you want to create a real progress bar. Here's an article that may already have been submitted http://www.dicks-blog.com/archives/2.../progress-bar/ /Fredrik |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Progress Meter during macro execution | Excel Programming | |||
Macro works in 2000 not XP for Progress Bar | Excel Programming | |||
Macro and slowing a progress bar. | Excel Programming | |||
Launch Macro in Access via Macro running in Excel??? | Excel Programming | |||
Running Excel Macro from VB6 | Excel Programming |