Combo mystery

[Bubba]

Hi,

Any idea why my combo box returns the row number in the cell that I have linked it to as opposed to what actually shows in the drop down bar?

Cheers

 

[Aladin Akyurek]

On 2002-05-02 07:52, Bubba wrote:
Hi,

Any idea why my combo box returns the row number in the cell that I have linked it to as opposed to what actually shows in the drop down bar?

Cheers

That's the way the comboboxes created using View|Toolbars|Forms operate.

You can get the actual selection itself by:

=INDEX(input-range-of-the-combobox,the-cell-link-of-the-combo-box)

 

[Bubba]

Aha! Cheers Aladdin... so how could I avoid this complication in the future when using combo boxes then or is there no other way around it?

Thanks

 

[Aladin Akyurek]

On 2002-05-02 07:59, Bubba wrote:
Aha! Cheers Aladdin... so how could I avoid this complication in the future when using combo boxes then or is there no other way around it?

Thanks

You could use View|ControlBox. But, that's no less messy.

Or, what about dropdown lists you can create with Data|Validation?

Aladin

 

[Bubba]

I've not tried that before... I'll give it a whirl!

Cheers