I’m sure there are ways to make this run faster, but for this exercise we’ll just focus on how to show a message in the status bar. Value Case Is As I said earlier, it’s easy to add a few messages in the status bar, so you can keep an eye on the macro’s progress.To test the code, you can create a workbook with numbers in cells A2: A100000. The extra bit of code might slow the macro down a little more, but it’s usually a good tradeoff – a few seconds slower, for a little peace of mind.Maybe it stopped, and you’ll be sitting here for the rest of the day, blissfully unaware of the problem.To help you stay informed, you can show messages in the status bar, to let you know what progress is being made.Is there any way that a macro can "read" this info from the statusbar or from somewhere else? See Efficient Spreadsheet Design However, there are MANY example of progess bars etc on the forum if you search.I have looked at the progress bar examples but they all seem to work on the same basis: A loop with a counter and the bar being updated each time during the loop. What's wrong with simply showing a message on your User Form by making a Text Box visible/non-visible, if you must cater to bad design?Select Next r Cell End Sub Sub Fast With No Flicker() Dim r Cell As Range Application. Send payment proof to [email protected] 31 days after purchase date.Screen Updating = False For Each r Cell In Range("A1: A15000") r Cell. Instant Download and Money Back Guarantee on Most Software Excel Trader Package Technical Analysis in Excel With 9.00 of FREE software! Convert Excel Spreadsheets To Webpages | Trading In Excel | Construction Estimators | Finance Templates & Add-ins Bundle | Code-VBA | Smart-VBA | Print-VBA | Excel Data Manipulation & Analysis | Convert MS Office Applications To......
Messages can be displayed in the gray bar at the bottom of the Access program window, controlled by a VBA procedure.
This is understandable since the workbook has thousands of formulae, and I wont ba able to avoid it (I think) Is there no way to read "excel calculated percentage" from somewhere? Okay I know this is quite big but is it that unusaul?
The workbook acts as a complete budgeting program so I was expecting it to be a bit bigger than usaul but does 45MB sound completely bizzare?
When you use the status bar to display a message to the user, that message will be displayed until your code returns control of the status bar back to Excel. This may be a problem when you use it to display a "Macro Complete" message -- the message will always remain in the status bar.
The Status Bar property of the Application object in Excel VBA can be used to indicate the progress of a lengthy macro.