Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Combobox data accidentally copied on different sheet
Hi,
I have placed about 21 comboboxes from the "Control Toolbox" on a standard worksheet (let's call it the "Selection Sheet"). It shows a 3-column list from which the user can select an entry and the bound column is stored in the cell underneath the combobox. The workbook has multiple sheets. Sometimes, when working on the other sheets, for no apparent reason (I can't reproduce it), contents & formatting of the filled comboboxes from the Selection Sheet are copied onto the sheet I am working on. This is highly frustrating and surely not by design. I have seen it happen on several computers, so it is not a specific problem for my PC configuration. Has any of you some idea why Combobox data is accidentally copied on different sheets? Your help is appreciated! Bennie Douma Excel 2002 *** Sent via Developersdex http://www.developersdex.com *** |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to update a worksheet and have data copied to another sheet? | Excel Worksheet Functions | |||
Accidentally saved over important data | Excel Discussion (Misc queries) | |||
Copied empty cells, give sorting problem in Data sheet | Excel Programming | |||
User Form-error 1004 unless opened in sheet w/combobox data | Excel Programming |