How to duplicate a column containing VBA code

[jrooney7]

I am creating a note-taking worksheet for which the design is a column for the user to note certain features of an item. The column contains several ActiveX comboboxes. I have learned how to insert vba code to allow the user to key into and out of the comboboxes as they move down the column for ease of end-use. The code I've entered works - yay! My problem arises from the fact that the end-users will need more than one of these columns based on the number of items they are documenting - this is never a set number (otherwise I would just do all the coding on my end now) and can range from 1 to 50 or so (I don't want to do all that coding!) Is there a way for the end-user to enter design mode and copy the existing column, insert a copy of the column, and have the code copy also so that the new column allows the proper tabbing in and out too? I'm using Windows 7 and Excel 2013. Thanks!

 

[alansidman]

crosspost: https://www.excelforum.com/excel-pr...olumn-that-contains-vba-code.html#post4758509

 

[Joe4]

While we do not prohibit Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules). This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.

Thank you.