Duplicate Combo box on next row

[Fjcunninghamjr]

Hi, this is my first post I hope I can explain clearly. I have a combo box (activex) on Row1 Col H, with all the items listed in the drop down.
When I go to the next row I would like the combo box to be automatically added to Row2 Col H and so forth. Can this be done?
Frank

[kev_]

Welcome to the forum

I cannot test with Excel2007 - so it may fail if something fundamental has changed in Excel 2016

EDIT -suggest you ignore this suggestion and test the one in the next post instead


Here is one way
Test in a new workbook
Add an active-x combobox above cell H1, rename it cb_1 and add items to appear in the dropdown

Right-click on sheet tab \ View Code \ paste this code into the code window \ {Alt}{F11} takes you back to Excel

Please Login or Register  to view this content.

How it works
- each combobox is named cb_ followed by row number (including the master in row 1 cb_1)
- this allows VBA to test for the existence of a combobox for the row selected
- if user clicks on row 6 and cb_6 exists then nothing happens otherwise a new combobox is added
- a few "sample" properties are mirrored to match cb_1

Question
Why are you using a combobox? Why not use a dropdown in the cell itself which is easy to copy and paste

[kev_]

Much simpler code - I forgot about the Duplicate method!!

Test in a new workbook
Add an active-x combobox above cell H1, rename it cb_1 and add items to appear in the dropdown

Right-click on sheet tab \ View Code \ paste this code into the code window \ {Alt}{F11} takes you back to Excel

Please Login or Register  to view this content.

[kev_]

@Fjcunninghamjr
Have you forgotten about this thread?