Hi all, I have a sheet with a 9000 row data table. I have
created a useform that will enable people do manipulate
the data table. I have some labels on textboxes plus a
button on the form. When the button is pressed I run some
code assigned to the button that runs right down the 9000
rows, I have written the code so that at certain points
it changes the text in some of the textboxes as a kind of
progress indication, and one of the labels changes
from "looking" to "found" etc, but the problem I am
seeing is that it doesnt update all the texboxes and
labels until after the code has completed. So the
textboxes only ever show the last change in the code.
I dont have screenupdating turned off and the code is
quite simple. Is it just a case that when executing code
assigned to a button on a form, that the form doesnt
update until the code execution has completed ?

If this is the case does anyone know a work around ?

After each update, put in the command
DoEvents

--
Regards,
Tom Ogilvy

"Neil" wrote in message
...
Hi all, I have a sheet with a 9000 row data table. I have
created a useform that will enable people do manipulate
the data table. I have some labels on textboxes plus a
button on the form. When the button is pressed I run some
code assigned to the button that runs right down the 9000
rows, I have written the code so that at certain points
it changes the text in some of the textboxes as a kind of
progress indication, and one of the labels changes
from "looking" to "found" etc, but the problem I am
seeing is that it doesnt update all the texboxes and
labels until after the code has completed. So the
textboxes only ever show the last change in the code.
I dont have screenupdating turned off and the code is
quite simple. Is it just a case that when executing code
assigned to a button on a form, that the form doesnt
update until the code execution has completed ?

If this is the case does anyone know a work around ?