Hello,
I have a workbook with some data. I plan to put in a combobox here, s
that the users select only predetermined values. I have done this also
But, I want to display a text in the adjoining cell, corresponding t
the menu item that is selected. for e.g Suppose a person select
"Apple" from the dropdown, the adjoining cell should show "Fruit". I
someone selects "Onion", it should display "Vegetable". I have one dat
range with Apple, Onion, etc, but when I select from the dropdown, i
displays the number (1, 2, etc). Is it possible for me to display
different text on the basis of my selection? Or is there any othe
method?

Pls do let me know.

Sujes

--
sujesh
-----------------------------------------------------------------------
sujeshn's Profile: http://www.excelforum.com/member.php...fo&userid=2525
View this thread: http://www.excelforum.com/showthread.php?threadid=38746