Drop Down / Combo Box return value

[Mark.B]

I have created a number of drop down / combo boxes using the 'Forms' toolbar. I have been able to set the 'input range' and the 'cell link', but was wondering if the drop down / combo box could return the name of the item selected rather than the positon / value e.g. If I had a list with London, Sheffield and Birmingham, and selected Sheffield using the drop down box, it would return "Sheffield" rather than "2".

Can anyone help ?

 

[HalfAce]

Mark,
For what you're asking you'd be better off using the ActiveX ComboBox from the Control Toolbox toolbar instead of the one from the Forms toolbar.

The properties and such are a little different to set up (not harder, just different) and you have more options available to you.

The input range is in the properties as "ListFillRange" and the cell link is the "LinkedCell" property.

Now that you've got all your first ones done, you get to start all over again!

Hope it helps,
Dan