Copy and insert column that contains vba code

Hello all, I am extremely new to vba and using it in excel, please use small words 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 tab 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 tabbing in and out too?

If it helps, the code I've inserted is this:
To key into a combobox:

Please Login or Register  to view this content.

To key out of a combobox:

Please Login or Register  to view this content.

In these examples, D9 is the underlying cell for ComboBox 16. Any help would be appreciated!!

Cross-post: https://www.mrexcel.com/forum/excel-...-vba-code.html

For stuff like this I would design a userform and copy all data from that userform to the next available empty column.
Then clear userform for next entry, and so one .....

crossposted: https://www.mrexcel.com/forum/excel-...-vba-code.html

Your post does not comply with Rule 8 of our Forum RULES. Do not crosspost your question on multiple forums without including links here to the other threads on other forums.

Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.

Expect cross-posted questions without a link to be closed and a message will be posted by the moderator explaining why. We are here to help so help us to help you!

Read this to understand why we ask you to do this, and then please edit your first post to include links to any and all cross-posts in any other forums (not just this site).

I've put something together for you.
Design and layout is for you to do, this is just functional.

This is fantastic! I tried it out and it works great! I have one question though - I cleared out Column C (the comboboxes and checkbox I had there originally) so that the userform would populate there first. But when I tried it, the data from the userform went to Column B. Looking at the code (and being very inexperienced), I'm not sure how to change that, but I figure it's this line:

Please Login or Register  to view this content.

I've attached a copy so you could see. Thank you for your help!

Replace existing code with this one.

Please Login or Register  to view this content.

You're welcome and thanks for rep+.