Userform Question
Am I able to keep a macro running even if a userform is showing,
I have put a code in the this workbook module userform1.show call start Thanks in advance Greg |
you can put a macro on the userform on activate event
Private Sub UserForm_Activate() call start End Sub double click on the form to get access to the code window Eric -----Original Message----- Am I able to keep a macro running even if a userform is showing, I have put a code in the this workbook module userform1.show call start Thanks in advance Greg . |
Greg,
No you cannot, the userform has to exit for the next line of code to be invoked. This is typical of the problem with progress bar forms, and the solution is generally to fir up the form, and then run the macro from within the form, either from the Activate event, or based upon some event happening. -- HTH RP (remove nothere from the email address if mailing direct) "Greg B" wrote in message ... Am I able to keep a macro running even if a userform is showing, I have put a code in the this workbook module userform1.show call start Thanks in advance Greg |
Thanks that was much better
Greg |
All times are GMT +1. The time now is 12:20 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com