I'm new to VBA but business requirements demand that I implement this.

I have a worksheet with a combobox1 in row1 cell - say cell B1 with some static data. For every time a user enters a value in Row2 - say A2 - , I would like the combo box in B1 to be copied to B2. I don't want the user to copy and paste for each time he/she enters data in each row. Likewise, when the user enters data in Row3 - say A3, I would like the combo box in B1 to be copied to B3

Also, if the user removes the data from row A2, I would like the corresponding combo box in B2 to be deleted. How do I accomplish this? And how do I access the value for these combo box control in VBA?

I'm putting the code in Worksheet_Change method.

For example:

Column A B C D
Row 1 combobox1 control
2 combobox1 control