Screen Updating with Userforms

Hi.

My Program is rather long with lots of flicking between workbooks, so I have turned off screen updating for the whole program. However I also have a several userforms that are called by the program and these do not disapear when there are unloaded anymore. Is this due to the screen updating being off?

I also have a sliding userform (gets wider if certain options are selected and then returns to its original size). At present when the width decreases back to the original size, I am left with a very unatractive black are where the form used to be. I have tried turning on the sreen updating while the userform changes size, but this appears to make no difference.

Are these issues the result of the screen updating being off?
If so could I trun it back on the line before the 'Unload Me' statement and back of the line after to solve the problem?
If not, can you suggest what is causing the display issues?

Thanks

Robyn

Hello RobynC,

I have never experienced the issues you are having, and had no success in recreating them. What version of Windows and Excel are you using?

Sincerely,
Leith Ross

Hi,

Hmm very odd. i am using Excel 2002 and I think we are on Windows XP Professional

Thanks Roy, I had noticed the multiple userforms as well.

I don't think I have much unnecessary selecting and activating, although there possibly is some that I could get rid of, but am not concerned with that at the moment. I shall adjust the code to just turn off screen updating for parts of the code, rather than the whole program