Hi
I've a INPUT sheet and a RESULT Sheet.
on the I NPUT sheet there is a button, and when clicked a macro is started putting values into the Result sheet with a loop.
For the progres sbar I've follows examples using a label control within a userform .
SO the vb code in teh Button_click Sub is something like this
sheet2.activate
'sheet2 is the result page
For i=1 to 8000
'code goes here
'progressbar
userfrom1.activate
userform1.label2.width=(i/TOT)*100
next
THe problem is that when the userform is displayed, I've to press the (x) close button in order for the loop (with i) to continue..
ANy suggestion how to get this to work?
Bookmarks