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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Transfering Data From Userform1 to TextBox1 in UserForm2 2
listbox click event question 4
pass a variable to activate 4
User Form 5
Fun with Userforms!!!! 9
Hiding a "Userform" instead of closing it??? 3
Macro to run when cell click 1
path error when pointing/going to userform1 1

Back
Top