Combo Box

[Guest]

I am new to this and have a simple question. How do you link values to the combo box so they appear in the dropdown list

Many thanks

Joe

 

[Frank Kabel]

Hi Joe
do you mean data - validation listboxes? If yes have a look at
http://www.contextures.com/xlDataVal01.html

 

[Jason Morin]

If you are creating a combo box from the control toolbox:

1. Populate a range (say A1:A5) with your list of values.
2. Create a combo box on the same worksheet.
3. Right-click the combo box and select 'Properties'.
4. Enter "A1:A5" (no quotes) in the 'ListFillRange'.
5. Enter an output cell (say J1) into the 'LinkedCell'.
6. Close the 'Properties' window and get out of exit
design mode.

HTH
Jason
Atlanta, GA

-----Original Message-----
I am new to this and have a simple question. How do you

link values to the combo box so they appear in the
dropdown list?

 

[JMay]

If from the combo box I select the value in A4 which is Paul, J1 returns 4
the position in the range versus the value in the range. What's wrong here?
TIA,

 

[JMay]

Ok, I was using the Forms route;
I switched to the Control route and it works,
Thanks,