garydp
10-07-2009, 03:58 AM
Hi
I have a progress bar that i use for my worksheet. when the data is being formated a form pops up with the progress bar. at present i am looping through the data and having to close the form with the progress bar and open it again each time it loops. is there away of keeping the form there all the time and just passing the variable to the form while the data is formated in the background??
thanks
gary
I have a progress bar that i use for my worksheet. when the data is being formated a form pops up with the progress bar. at present i am looping through the data and having to close the form with the progress bar and open it again each time it loops. is there away of keeping the form there all the time and just passing the variable to the form while the data is formated in the background??
thanks
gary