combo Box

[Guest]

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 th
Combo Box. Go to the Control tab. For input range, select the rang
of cells that has your options. For Cell Link, select the sell yo
want to have the reselt placed (this can be on a different sheet). Th
value in that cell will show 1,2,3,4, etc, depending on the optio
number selected from the original list