Combo Box - Cell Link

[MTBer]

When using a combo box, my cell link always returns a value, which
then use as a index to retrieve the seletion.

Is it possible to set the cell link to the selection made in th
combobox list rather than a numeric value?

thanks,
Pau

 

[Tim Otero]

Paul,

Instead of using the combobox from the forms toolbar, use the one from
the control toolbox. To fill the contents and set its linked cell, open
up its properties window.

tim

 

[Dave Peterson]

Or maybe Data|Validation would suffice.

For lots of nice notes, visit Debra Dalgleish's site:
http://www.contextures.com/xlDataVal01.html