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?

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.


--
Lotus123
------------------------------------------------------------------------
Lotus123's Profile: http://www.excelforum.com/member.php...o&userid=28611
View this thread: http://www.excelforum.com/showthread...hreadid=484676