combo Box

[rpalmer4]

When installing a combo box into a spreadsheet how do you set up the
properties to link the selection within the combo box? I know that within the
properties list fill range I can list my choices within the combo box
(A1:a10) when the end user chooses A1 within the combo box and subject A1 is
on sheet 2 how do I set this up? Is it in the properties or is it in the VB
macro?

[Lotus123]

It sounds like you might be adding a combo box via the "control" toolbar. Try adding a Combo Box via the "forms" toolbar.

From there, right click and select format-control after you create the Combo Box. Go to the Control tab. For input range, select the range of cells that has your options. For Cell Link, select the sell you want to have the reselt placed (this can be on a different sheet). The value in that cell will show 1,2,3,4, etc, depending on the option number selected from the original list.