Data Validation - Drop Down Font

[jwarin]

I'm using a data validation with the criteria being two values, a check mark and an X from wingdings. Arial doesn't have either of these so I had to use wingdings. The problem is, the drop down menu converts them to arial which makes the two possible values a different versions of a "u". The cell still populates with a winding value after one of the 'u''s is selected but I would like the wingdings to show up in the drop down. Any idea how to changed it?

 

[Von Pookie]

You can not specify the font used in the data validation dropdown.

That being said: what is wrong with using a plain text 'X' and another text value in place of the checkmark wingding?

 

[RoryA]

If you just want a tick and a cross, why not use the square root sign and X from Arial?

 

[Gerald Higgins]

And consider also Y and N, or 1 and 0, and so on.

 

[Smitty]

Welcome to the Board!

How do your users know the difference between the check and X?

Why not something straightforward like Yes/No?

 

[unley]

Hi there, I'm a very newbie in vba and this site has helped me alot. I was asking this same question too. In column E, I have the tick and in column F, I have the X so here's the formula that may help but you will have to adjust the code a bit depend on where you want the ticks and cross

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
  If Target.Cells.Count > 1 Then Exit Sub 
    If Not Intersect(Target, Range("e1:e10000")) 
      Target.Font.Name = "Marlett" 
      If Target = vbNullString Then
         Target = "a" 
      Else
         Target = vbNullString
      End If 
 
    ElseIf Not Intersect(Target, Range("f1:f10000")) 
      If Target = vbNullString Then 
         Target = "X"
      Else
         Target = vbNullString
      End If 
    End If
End Sub

 

[lenze]

Nice code unley:
As a side note, an "r" in Marlett font produces a very nice X

lenze

 

[unley]

Thank you lenze and this is another news for me like an "r" in Marlett font produces a very nice X