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? |
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? |
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? |
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? |
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? |
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? |
how do you set up a progress bar when running a macro in excel
Thankyou to everyone for your help. Much Appreciated
|
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 |
All times are GMT +1. The time now is 06:19 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com