Use Defined names in excel to list combobox

[ydevadiga]

Can i list combobox using defined names?

 

[MickG]

Hi ,For Userform Try:-

Private Sub UserForm_Initialize()
With ComboBox1
    .RowSource = "MyRng"
    .ListIndex = 0
End With
End Sub

For sheet try:-

[COLOR="Navy"]Sub[/COLOR] MG03Aug12
[COLOR="Navy"]With[/COLOR] ComboBox1
    .ListFillRange = "MyRng"
    .ListIndex = 0
[COLOR="Navy"]End[/COLOR] [COLOR="Navy"]With[/COLOR]
[COLOR="Navy"]End[/COLOR] [COLOR="Navy"]Sub[/COLOR]

Regards Mick