Using Symbols Like Tick Cross in Drop Down List in Excel Worksheet

An MS Excel user wants to create a drop-down list against item names and this drop down list should offer only two options: a tick mark tick-mark or a cross cross . We have used Excel VBA or a macro to be able to display both the characters in a drop-down list. The VBA code or macro code is given below:

Sub usingSymbols()

Range(“B2:B6”).Select

With Selection.Font
.Name = “Wingdings 2″
.Size = 12
End With

With Selection.Validation

.Add Type:=xlValidateList, Formula1:=”P,S”
End With

Range(“B2”).Select

End Sub

Watch the video below to understand how we can use symbols in a drop-down list on an Excel worksheet quickly and easily:


One thought on “Using Symbols Like Tick Cross in Drop Down List in Excel Worksheet

  1. Simon

    Great video, got this to work perfectly but I now have a question. I have set this code across columns J to AN.

    What I now want to do is if there is a a tick “P” in the same row but in column J, K, L or M then then cell in one of the rows N to AN turns a colour dependant on formatting.

    Do you know how to do this?

    Reply

Leave a Reply

Your email address will not be published. Required fields are marked *