VBA - copy combobox

[pmkdatabase]

Hi,

I am creating a simple form with a Worksheet (not a userform) where I will use VBA from Access to insert a varying number of records in column A. Columns will have unchanging headers. One of the other columns will have a combobox for data selection. I know how to do all that.

What I don't know is how with VBA, to copy the combobox to all the rows that have values in column A.

Thank you.

 

[pmkdatabase]

I should have mentioned the combobox resides inside a cell. I used the data validation method to create it. It is not the cbo from the toolbox.