Using Symbols Like 'Tick' and 'Cross' in Drop-Down List in Excel Worksheet

Home More Excel (VBA) Training Videos


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:



More Info

Home More Excel (VBA) Training Videos