Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 161
  • Last Modified:

HELP! I need an expert to help me display a splash page while macros are running

I have a few loops running and as the macro runs through the LOOOONG data, it can cause a little dizzyness.  Is there a way I can introduce a splash page that 'pops up' when The macro begins (maybe one that says loading) and disappears when the last macro is completed?
0
Dina-mic
Asked:
Dina-mic
1 Solution
 
IeuanJCommented:
Create your splash form then just show/hide it as necessary.

Load Form2
Form2.Show

'do your macro stuff here

Form2.Hide
Unload Form2
0
 
Dina-micAuthor Commented:
The splash pages load but do NOT run at the same time as the macros... that's what I need
0
 
craigewensCommented:
Just put IeuanJ's code inside your macro modules then.
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
Dina-micAuthor Commented:
The problem still occurs... you have to manually shut down the splash page.  Optimally this would happen:

1.  Run the macro
2.  Splash page pops up and says "loading..."
3.  Macros run in the background
4.  Macros finish, splash disapears.

The splash is needed to take the user's eye away from the data scrolling in th backgroun (built into the macro itself)

0
 
YeaYuhCommented:
Personally I would just do an

Application.ScreenUpdating = False
this will prevent any changes from being shown on the screen, and will make the macro run faster

Then when the macro is done just do

Application.ScreenUpdating = True
0
 
Dina-micAuthor Commented:
You're a FRICKEN star!
0
 
IeuanJCommented:
I still dont see why my code doesnt work, just close the window as the last thing in your macro, it's not hard to work around.
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now