Refreshing a form?
Posted by Cory on August 20, 2001 1:26 PM
I have a form with a start button. underneath the start button i have a couple dozen tiny labels in a row right next to each other. When I press the start button, a macro starts that does a bunch of cut, copy, pasting, etc. to an underlying workbook. Laced throughout the macro code are lines that change the backcolor property of my tiny labels from null to blue, one at a time (simulating a progress meter for the running macro).
My problem:
the form doesn't show the changing backcolors for my tiny labels until there's a break in the code (a message box, for example) or until the code finishes executing. there's only one msgbox in the middle of the code, so the 'progress meter' looks like it's going in two big chunks instead of 'progressing'...
is there a way to display the changing backcolor properties as the macro is running? I've tried to find a refresh property or some such but to no luck...
Any help would be greatly appreciated...
Cory