PDA

View Full Version : How to avoid gosth userforms on screen



CarlosB
12-04-2008, 02:06 PM
I have two userforms on screen, one pops out when I click a button in the spreedshet; the second userform pops out when I click a button in the first form. The problem I have is, when the second userform shows up, if I move it I can see on the screen the same userform as many times as I move it. Is there any way to prevent this from happening? Originally I thohght I could eliminate this problem by using

Application.ScreenUpdating = True
but the problem still persists. I have attached a jpg showing my problem.http://img139.imageshack.us/img139/575/duplicatepa8.jpg

CreganTur
12-04-2008, 02:11 PM
Take a look at the Unload method. This unloads, or closes, a userform.

lucas
12-04-2008, 02:46 PM
something else going on here I suspect......you shouldn't have that many showing unless they are opened repeatedly....

post the workbook that is doing this.......