Hi all,

Here is an interesting problem I'm hitting a wall with.

I have a sheet that has a dynamic width and length.
The data is based off formulas and data from other sheets that are populated via ado record sets.
But I digress.

I need to put a list box in every cell via vb/a code that would allow a user to select a country of manufacture ( currently USA and Mexico), once selected the drop down list would display the results of a formula.

I need the list box to be locked to a given cell that would grow or shrink and rows or columns are resized or hidden.

The design is not case in stone but I need a way where the accounting people could click on a cell, select a country and once the list closes, the values is the result of a formula. I need to also have the list have a default selection so the user don't have to manually select each control. right now using test data, the width has 14 columns and 24 rows.
for a total of 336 unique cells, and each cell will need a selectable country of manufacture list box.

btw: Using Excell 2010 edition

Any ideas how to do this or is it even possible?