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.
In actuality the Information Page doesn't display until after the Run_scoring sub has run.
???? Why
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