Copy ActiveX ComboBox from One Sheet to Another and Then Have it Execute Code

I have a sheet (Sheet1) with 20 combo boxes on it. I want to copy these combo boxes to a new sheet that is created using a command button in the same location. I have successfully made the new sheet with new command buttons that will run code when clicked. I want to do the same with the combo boxes, but just copying them instead then having them run already existing code. I'm not sure if this can be done with ActiveX Controls, but I would like to try. Here is my code:

Please Login or Register  to view this content.

Welcome to the forum.

Pls

Use code tags around code.

Posting code between

Please Login or Register  to view this content.

tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here


I have added code tags to your post. As per forum rule 3, you need to use them whenever you put any code in your post. Please add them in future