Multipage wizard timing

Chuck6475

Board Regular
Joined
Sep 30, 2012
Messages
126
2003 w7

I'm using a Multipage control to show the user several different Userform pages. During the gathering of data I periodically save the file and do some interim results calculations. This takes a while and users are impatient, therefore I decided to devote a Multipage page to simply a message label (Informational page)telling the user the program was backing up.

Seemed to be a simple solution. However the Information Page doesn't display prior to the spreadsheet running off and doing the results.

Code:
              isave = MultiPage1.Value
                        MultiPage1.Value = 5             'Information Page           
                            ActiveWorkbook.Save
                            Run_scoring         'Scores results to-date, does not do ESC unless all scores are in
                           
                            Create_PDF          ' Creates PDF of appropriate sheets

                        MultiPage1.Value = isave

In actuality the Information Page doesn't display until after the Run_scoring sub has run.

???? Why
 

Excel Facts

Bring active cell back into view
Start at A1 and select to A9999 while writing a formula, you can't see A1 anymore. Press Ctrl+Backspace to bring active cell into view.

Forum statistics

Threads
1,223,885
Messages
6,175,179
Members
452,615
Latest member
bogeys2birdies

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top