Duplicated form at runtime

  • Thread starter Thread starter lily
  • Start date Start date
L

lily

I have a combbox in one worksheet. When I change the item in the
combbox, I let a form show up. But at runtime, each time I try to move
the form, the form duplicates itself in my screen. Could someone what
happens and what plays this trick? Thanks.
 
I know ive had this when I havent unloaded the previous form
properly....but I think it might help if you posted your code, someone
might spot the bug then.

Duncan
 
Is the userform really duplicated or is it just the image that's sticking
around.

Maybe
application.screenupdating = true
'move the form or show the form
application.screenupdating = false
 
Dave;,

I think I was perhaps a bit quick to reply, as on reflection the screen
updating sounds like the obvious culprit. (I forgot about that)

Duncan
 

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

Similar Threads

Linking ComboBoxes through VBA 1
ComboBox 2
user form, set values 2
three types of comboboxes. 4
Filling out paper forms 3
Excel 2003 Runtime error 40036 6
New Line Items at Runtime 1
Textbox labels at runtime 1

Back
Top