Combo Box to output test
Posted by Robert on January 25, 2002 5:47 PM
A combo box out outs a number. How can I make this text or convert the number variable to text.
What I am creating is a simple sheet to allow teachers to choose different options from a drop down which I want to post to another column field. So if they choose "printer" from the dropdown then the word printer should appear in my output field instead og a number.
Posted by Aladin Akyurek on January 26, 2002 1:41 AM
Did you create th ComboBox thru View|Toolbars|Forms?
If so, what is its Input range and Cell link?
===============
Posted by Chris D on January 27, 2002 2:00 AM
Hi Robert,
could you use data validation instead ?
Put your list of options somewhere safe, then in the cell you want the choice to be in, choose:
data
validation
allow = list
scource = your range of options
in cell dropdown is checked
play around with the other options at leisure....
HTH
Chris
