View Single Post
  #3   Report Post  
Bob Phillips
 
Posts: n/a
Default

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