ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.
One of a set of tools we're offering as a way to say thank you for being a part of the community.
Course Of The Month
8 days, 3 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
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
Workbook link problems after copying tabs to a new workbook?
David Miller (dlmille)
Intro
Have you either copied sheets to a new workbook, and after having saved and opened that workbook, you find that there are links back to the original sou…
Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
Suggested Courses
Course of the Month8 days, 3 hours left to enroll
729 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.