MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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