ActiveX Combo Box ListFillRange = Worksheet Named Range

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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"
 
For a named range "List1"

This worked for me

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


as an example.
 
Back
Top