S
swinkcat
I put together a form in Excel 2000. In it are 2 combo boxes that work
correctly in the worksheet. It links to a data series that show up i
the combo's box pull down and when a selection is made, it correctl
places a corresponding number to a designated field.
The problem I'm having is when I copy the sheet. If I make a copy fro
the original excel worksheet, the combo box gets copied and the ne
worksheet works correctly. When I MAKE A COPY FROM THE COPY, I LOOS
THE COMBO BOX in the new copy. In other words:
Original to Copy 1 - Works ok
Copy 1 to Copy 2 - Combo Box disappears
Does anyone have a solution or work around for this? If it's a VB
code, please be very detailed as I don't have VBA skills
correctly in the worksheet. It links to a data series that show up i
the combo's box pull down and when a selection is made, it correctl
places a corresponding number to a designated field.
The problem I'm having is when I copy the sheet. If I make a copy fro
the original excel worksheet, the combo box gets copied and the ne
worksheet works correctly. When I MAKE A COPY FROM THE COPY, I LOOS
THE COMBO BOX in the new copy. In other words:
Original to Copy 1 - Works ok
Copy 1 to Copy 2 - Combo Box disappears
Does anyone have a solution or work around for this? If it's a VB
code, please be very detailed as I don't have VBA skills