You can create a list of symbols on your worksheet:
Select a cell, and hold the Alt key, then on the number keypad, type a 1
Press the Enter key, and the cell should contain a smiley face.
In the cell below, use the same technique, but type a 2.
Continue with the list to create a variety of symbols
Then, use the technique shown here, to create a data validation dropdown
list:
http://www.contextures.com/xlDataVal01.html
wrote:
how to have a drop downlist with object like smiley
--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html