Show Unicode characters in dropdowns in Excel VBA Forms

AddItem method is used to add items to a combobox(dropdown) list in VBA. But we can’t use that method to add items containing Unicode characters. Luckily there is a workaround for that. So in this lesson I have explained how to add items containing Unicode characters to a combobox list.

RESOURCES
Learn advance techniques related to Excel VBA userforms

How to Use Scroll Bar in Userform

Change attributes of controls inside VBA userforms in easier way

Reference Dynamic Userform Name

Loop Through All the Controls of a VBA UserForm

Useful VBA form tips

How to Add Additional Controls in Excel VBA

How to add labels to VBA Userforms

How to Add Textboxes to VBA Userforms

How to Format Label Text in VBA Forms (To Give Professional Look)

Show Userform Automatically When Opening Excel File

For Next statements

How to Use For Each Next in Excel VBA

Get the Day Name of a Date Independent of Regional Settings (This macro uses For Next statement)

Concatenated using VBA(This macro use Nested For Next Statement)