Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.
Solved
Display Excel Form while VBA code runs
Posted on 2012-12-31
I have an excel workbook with a lot of custom code going on in it and it takes a while to calculate (5-7 seconds)
Because of this, instead of leaving calculation set to Automatic, I manage it with VBA as the user clicks around and does different things (toggling calculation on and off, and recalculating programmatically as necessary). All of this works fine.
As a nice-to-have, I'd like to display a form with a label on it that says "Calculating. Please wait" while the calc occurs so the user doesn't just think their computer is broken. Problem is, when I display such a form via code, the rest of the code doesn't complete until I close the form manually again (clicking on the X button). Is there a way around this?
In other words: is there a way to make the form run asynchronously from the code that displayed it?
AR
Because of this, instead of leaving calculation set to Automatic, I manage it with VBA as the user clicks around and does different things (toggling calculation on and off, and recalculating programmatically as necessary). All of this works fine.
As a nice-to-have, I'd like to display a form with a label on it that says "Calculating. Please wait" while the calc occurs so the user doesn't just think their computer is broken. Problem is, when I display such a form via code, the rest of the code doesn't complete until I close the form manually again (clicking on the X button). Is there a way around this?
In other words: is there a way to make the form run asynchronously from the code that displayed it?
AR
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
2
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
If you need to forecast numbers -- typically for finance -- the Windows and Mac versions of Excel 2016 have a basket of tools to get the job done.
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
Suggested Courses
Course of the Month8 days, 11 hours left to enroll
721 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.