Form Combo Box
 

Hi

In Cell A1 I have a link to a Index function that uses Indirect(A1) to look
up a named range.

I also am making a form, and I just want the form to choose between some
names that are located in cells "Z1:Z10" of the worksheet and put the
selected name in Cell A1.

How do you link the combo box to cells Z1:Z10, and put your choice in cell A1?

Thanks a lot for your help

Hi
see:
http://www.contextures.com/xlCondFormat01.html

--
Regards
Frank Kabel
Frankfurt, Germany

Jeff wrote:
Hi

In Cell A1 I have a link to a Index function that uses Indirect(A1)
to look up a named range.

I also am making a form, and I just want the form to choose between
some names that are located in cells "Z1:Z10" of the worksheet and
put the selected name in Cell A1.

How do you link the combo box to cells Z1:Z10, and put your choice in
cell A1?

Thanks a lot for your help