ActiveX Combo Box ListFillRange = Worksheet Named Range
 

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"

ActiveX Combo Box 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.

--
Regards,
Tom Ogilvy\


"Philip J Smith" wrote:

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"
.
End With

End Sub


Regard

Phil