| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Duplicated form at runtime
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. -- lily ------------------------------------------------------------------------ lily's Profile: http://www.excelforum.com/member.php...o&userid=33150 View this thread: http://www.excelforum.com/showthread...hreadid=551877 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Duplicated form at runtime
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Duplicated form at runtime
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 Duncan wrote: 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 -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Duplicated form at runtime
Does your form have an on click event that creates a copy of the form?
-- HTH... Jim Thomlinson "lily" wrote: 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. -- lily ------------------------------------------------------------------------ lily's Profile: http://www.excelforum.com/member.php...o&userid=33150 View this thread: http://www.excelforum.com/showthread...hreadid=551877 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Duplicated form at runtime
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Textbox added to Form at runtime too small, can't control size andchange event won't trigger | Excel Worksheet Functions | |||
| Textbox added to Form at runtime too small, can't control size andchange event won't trigger | Excel Worksheet Functions | |||
| Duplicated cells | Excel Worksheet Functions | |||
| Adding controls to a form at runtime | Excel Programming | |||
| Duplicated rows | Excel Discussion (Misc queries) | |||
Hybrid Mode
