View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Nigel Brown[_2_] Nigel Brown[_2_] is offline
external usenet poster
 
Posts: 18
Default Screen refresh problem.

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