I have a piece of code that prints a set of reports, some of the reports are opened from Excel then printed. I am looking for a way to put a ‘PopUp’ form on the screen during the time that the code is executing.
I created a small form to use as the popup form and named it frmWait. How do i go about coding in the load/show of the form, the call of the other sub (P22 is the other subs name), then the unload of the form.
Here is what I have tried, but I get a variable not defined error. Upon clicking the ‘debug’ button the frmWait.Show gets highlited.
Function p22a() frmWait.Show 'Call P22 Unload frmWait End Function
What am I doing wrong. BTW, this is my first time attempting to open a form through code (does it show)