Selecting a value in a drop down list, and showing a symbol

**hadar** · 01-05-2011, 03:12 PM

Hi everyone,

I have a checklist file, which contains few options (done, irrelevant, not done, once a year... ), but I need to display a corresponding symbol in "Wingdings" font.
for example, "done" means a square with a "v" inside, and "irrelevant" means a black square, and so on...

So I need to create a drop down list, contains values from column A, and when one of them is selected, I want to display values from column B (Symbols), in other font.

I hope I explained myself well..

Thank you,
Hadar

**JBeaucaire** · 01-05-2011, 03:47 PM

So, the list values are in A1:A10.
The Wingding values are in B1:B10.

The drop down list of values from column A are in cell ______?
You want to display the matching wingding in cell _______?

**hadar** · 01-05-2011, 05:52 PM

Ok, lets say I have a column named "Status", which is a drop down list at H2:H14.
When I choose "Done" at H2, I need the same cell to display the symbol instead of the word.

Please, look at the attachment.
checklist.xls
Thanks.

Originally Posted by JBeaucaire

So, the list values are in A1:A10.
The Wingding values are in B1:B10.

The drop down list of values from column A are in cell ______?
You want to display the matching wingding in cell _______?

**JBeaucaire** · 01-05-2011, 06:59 PM

A drop down will display the value selected in the cell in which it was selected.

If you wish to select one thing and have something else completely display, that would require VBA.

To do it without VBA, perhaps you could use a trick and make the dropdown a really skinny column so you can't actually see the value you chose, then the next column over would use a VLOOKUP() to lookup and display your desired value from the table. That could work.

**JBeaucaire** · 01-05-2011, 07:11 PM

Here's the VBA approach installed into your sheet.

Option Explicit

Private Sub Worksheet_Change(ByVal Target As Range)
Dim cell As Range

Application.EnableEvents = False
    For Each cell In Intersect(Target, Range("H2:H" & Rows.Count))
        If cell <> "" Then
            cell.Value = Application.WorksheetFunction.Index(Range("Symbols"), _
                Application.WorksheetFunction.Match(cell, Range("Codes"), 0))
        End If
    Next cell
Application.EnableEvents = True
End Sub

**hadar** · 01-05-2011, 08:46 PM

Ok, I'll try that...
Thank you very much for your help.

Have a great week...

**Mouses** · 05-30-2011, 12:41 PM

Hi Jerry,

It's just gone 2am here in Aus and I've finally found what I've been looking for, the spreadsheet that you made for Hadar. Very excited to find it, but unfortunately when I down loaded it it isn't returning the "symbol" it's returning the data selected in the drop down. Can you help?

I can't see a way to load up your file with the data that I have typed over your "symbol" and "codes" ranges, but I haven't changed anything other than the Font!

Attached is the file. Have I broken it??

Can you help? I'm so tired!

Mouse

**Mouses** · 05-30-2011, 07:49 PM

Ah, I see :-) The content had to be enabled. That's for this Jerry, you rock.

**JBeaucaire** · 05-30-2011, 09:29 PM

Glad it worked for you, the forum is a great research tool.

Selecting a value in a drop down list, and showing a symbol

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Selecting a value in a drop down list, and showing a symbol

Re: Selecting a value in a drop down list, and showing a symbol

Re: Selecting a value in a drop down list, and showing a symbol

Re: Selecting a value in a drop down list, and showing a symbol

Re: Selecting a value in a drop down list, and showing a symbol

Re: Selecting a value in a drop down list, and showing a symbol

Re: Selecting a value in a drop down list, and showing a symbol

Re: Selecting a value in a drop down list, and showing a symbol

Re: Selecting a value in a drop down list, and showing a symbol

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions