hi, !

embed a combobox from "controls toolbar" (populate it as needed)
and use the '_selectionchange' event in "that" sheet to set it's "LinkedCell" property

hth,
hector.

__ OP __
Is there anyway to select a cell, say B1, then click a selection from a Combo Box
and have it populate B1 with that value.
I know how to add one Combo Box and associate it with 1 cell
but I want to select say cell B2, select an entry from the same Combo Box
nd have that value populate B2 with the new entry vs. changing B2 to the B1 Combo Box value.

I basically want 1 Combo Box on a sheet, select different cells in the same sheet
and have those values populate the cell based on the Combo Box selection.

I don't think I can do it but wanted to ask.