Userform1-Can I override the need to click on the form?
 

I have a long running macro and would like to display some variables to see
where I am in the processing. When I show the Userform that I created for
this purpose, I am force to click on it to keep the macro going. Is there
any way to avoid the click and just show the userform throughout the process?

Thanks!
--
sbw

Userform1-Can I override the need to click on the form?
 

Hi
you could either
- show the form in modeless mode:
frmMyForm.Show vbModeless
- or run the macro from the form: The form shows "This macro may take
several second. Continue?" if yes command button... run the macro and display
the % in a label.:
Sub cmdOk_Click
'run macro if not already running
End Sub

Regards,
Sebastienm

"sbweid" wrote:

I have a long running macro and would like to display some variables to see
where I am in the processing. When I show the Userform that I created for
this purpose, I am force to click on it to keep the macro going. Is there
any way to avoid the click and just show the userform throughout the process?

Thanks!
--
sbw