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?