ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Using symbols for drop down list boxes? (https://www.excelbanter.com/excel-worksheet-functions/22610-using-symbols-drop-down-list-boxes.html)

Sumeet Benawra

Using symbols for drop down list boxes?
 
Can anyone help me with this simple problem? I would like to create a drop
down list with a "tick" mark and a "x" mark as the available values. These
are symbols from the wingdings font available from insert-symbols menu.

When I originally created the reference cells with the symbols to use as my
source for the drop down list, the symbols appear as characters such as "û"
or "ü" in the cell with the listbox. I tried to then adjust my list box
settings in the data-validation menu by typing in the actual character code
for the symbol in the source box; For example, by pressing alt+252 which is
the character code for the tick mark that I want to use. This still did not
show the tick mark.

Is there any functionality within Excel that would allow me to use symbols
for a drop down list?


All times are GMT +1. The time now is 12:57 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com