ActiveX Combo Box ListFillRange = Worksheet Named Range

's Computer Specifications

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"

's Computer Specifications

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

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Filtered list for Combo Box ListFillRange - Nested Combo Boxes	=?Utf-8?B?RG9jdG9yRw==?=	Microsoft Excel Programming	4	30th Jan 2009 10:18 PM
Do not specify worksheet in a named range	=?Utf-8?B?aG1t?=	Microsoft Excel Misc	3	18th Sep 2007 01:30 PM
Getting a named range to appear in another worksheet	=?Utf-8?B?Sm9obg==?=	Microsoft Excel Misc	2	28th Jul 2007 02:12 AM
combo box named range	=?Utf-8?B?QkI=?=	Microsoft Excel Misc	2	21st Jun 2005 04:27 PM
ListFillRange linked to named range in a closed remote file	=?Utf-8?B?Q2h1Y2sgSHlyZQ==?=	Microsoft Excel Programming	0	14th Apr 2005 09:42 PM