ActiveX Combo Box ListFillRange = Worksheet Named Range

[Philip J Smith]

Hi.

I want to populate the ListFillRange property with the contents of a
worksheet named range.

How do I attribute the named range as the ListFillRange?

Is it something like

Private Sub cboBand1_Change()

With combo.cboBand1
.ListFillRange="Worksheet Named Range"

 

[Tom Ogilvy]

For a named range "List1"

This worked for me

Private Sub CommandButton1_Click()
ComboBox1.ListFillRange = "List1"
End Sub


as an example.