Screen refresh problem.

N

Nigel Brown

I have a userform that allows the user to input data and then save to
another workbook. I use a sub procedure to validate the user input and
then save to the workbook. Once the input is saved I close the
workbook that has been written to and return to the userform.
However if I move the input form a trail of input forms appears on my
screen, leading me to suspect windows cant keep up refreshing the
screen. I added doEvents after the call to close the workbook and
before I exit the sub but this has not cured the problem.
Does anyone know how I can solve this problem?

Regards
Nigel Brown
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top