Is there a way I can do something similar to a list/combo
box in multiple cells. I have a vlookup based on the
value assigned to a cell by a list box; I would like to
be able to drag the list box to fill the cells below (but
with a different value every time).

i guess the point is to have the abilty to pull all my
formulas down and not have to recreate the list box of
linked cell every time.

Any suggestions would be greatly appreciated.

Thanks in advance!