Progress bar userform

[Glory]

Userform1 loads userform2 (progress bar). Code runs, userform2 tracks its progress with an expanding listbox.

I can't figure out how to trigger the code without forcing the user to press another buttonon the second form (the second form is meant to be a progress bar, and nothing else).

The second form doesn't actually appear until after the initialize event is done, so I can't use the initialize event.

Any ideas?

 

[rs2k]

Can you not 'call' your macro?

Sub MyMacro()
Call Macro1
Call Macro2
End Sub

Or if you post your code we may be able to help,

Cheers
Colin

 

[Glory]

I wound up using the Activate event.

But there's another issue that I'm having trouble figuring out.

I'm using this UDF to prevent "Now Printing" messages from popping up onscreen. But userform2 holds a progress bar that needs to be able to update.

So I'm wondering how to modify that function to prevent Now Printing message from popping up, but still allow the progress bar to update.

It might help if I knew how to find the "windows handle" number of the "Now Printing" dialogue windows, so that I could target them specifically.