Monday 20 January 2014

How to add the Created Names to Combo box in Excel using VBA

I have created the ComboBox2 in Excel Sheet.

I have created One Name Language and Need to add the Language to ComboBox.

With Sheet1.ComboBox2
    .ListFillRange = ThisWorkbook.Names("Language").RefersTo
    .ListIndex = 0
End With