VBA - How to open a pop-up that does not stop the macro?
Closed
Maxine S
Posts
1
Registration date
Friday May 24, 2013
Status
Member
Last seen
May 24, 2013
-
May 24, 2013 at 02:31 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 - May 27, 2013 at 12:03 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 - May 27, 2013 at 12:03 PM
Related:
- Pop up message in excel without macro
- Spell number in excel without macro - Guide
- Pop up reminder in excel free download - Download - Spreadsheets
- Excel date format dd.mm.yyyy - Guide
- Macros in excel download - Download - Spreadsheets
- Screenshot in excel - Guide
1 reply
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 16, 2023
547
May 27, 2013 at 12:03 PM
May 27, 2013 at 12:03 PM
Hi Maxine,
Don't know if it's possible but I wanted the same thing (a while ago) so I created a hidden sheet (displaying a message to wait a while.).
The macro would then unhide and activate the hidden sheet.
Then the macro would kill the screenupdating.
At the end the macro hide the "hidden" sheet again and restored the screenupdating.
I know it's also possible to create a timed message box which would dissapear after a fixed amount of second.
Let me know if you need help with any of the two given options.
Best regards,
Trowa
Don't know if it's possible but I wanted the same thing (a while ago) so I created a hidden sheet (displaying a message to wait a while.).
The macro would then unhide and activate the hidden sheet.
Then the macro would kill the screenupdating.
At the end the macro hide the "hidden" sheet again and restored the screenupdating.
I know it's also possible to create a timed message box which would dissapear after a fixed amount of second.
Let me know if you need help with any of the two given options.
Best regards,
Trowa