Most of us use VBA to automate tasks of varying complexity – some macros are executed in a flash, but others take hours to run.
While there are users who are happy with just a If you are thinking, “Hey I can see exactly what is going on, why would I need to display messages?
You can use it to display the progress of a VBA procedure, or indicate that the procedure is complete.
The code to put a message on the status bar is shown below.
It works fine, but I never know how far along the macro has gone. The BEST Lookup function of all time Dynamic Named Ranges are your bestest friend Hope that Helps Roy New users should read the Forum Rules before posting For free Excel tools & articles visit my web site If I have helped you and you feel like putting your hand in your pocket please make a donation to Children in Need Roy UK's Web Site roy UK's Database Form Where to paste code from the Forum About me.
A specific problem is cells which don't have borders show up with very light grey borders in Outlook. Ti A In my Excel spreadsheet I have a column to store the email addresses of my clients. Create Item(0) On Error Resume Next With Out Mail . Once Status is updated to "Complete", it would be helpful to be able to run a macro/click a button that would perform the transfer. Cut as few of the shortest cut lengths possiable Due to the fact that I will have to convert this to a PLC application when completed, I want to find a mathmatical way to do this inside excel and not use the "solver"....
Every time I click on the text of an email address, it automatically opens Outlook with a new message composed to that address. I don't even use Outlook for my email and this is really frustrating. Assuming that I/we can come up with an equation to do this ..... Hello, I am new to using Excel and I am not very computer literate.
I have the code written so the progress bar shows the progress by taking the total number of loops that need to happen divided by the number of times the loop has taken place.
During each loop, the macro copies and pastes data and formats it, then loops again after updating the progress bar.