I am creating a data entry sheet using ActiveX Combination boxes.

I have created a pull down list in the first cell of each column using ActiveX Developer Tab Tools and then used a macro to copy the combination box to each cell below it in the column giving the same ListFillRange values in the box but a different corresponding Linkedcell value to place the Selected data. Ideally the selected data would appear in the next column in the same row the pull down box is located.

The issue I am tackling now is the successive pull down boxes the macro creates do not line up with the underlying cells they float over and as I go down the column the corresponding linked cell that the selected data is deposited into gets increasingly mis-aligned with the boxes generating the inputs.

I need a method to code the pull down box to exactly fit within the cell so that once the macro generates a copy below it - it will line up with the row parameters and exactly fit within each cell.

I need to generate at least 100 data entry rows and have over thirty columns with different required column widths.

Is this possible? What is the best approach to tackle this conundrum?