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:
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!!Please Login or Register to view this content.
Cross-post: https://www.mrexcel.com/forum/excel-...-vba-code.html
Bookmarks