named range
 

hi,

i have a form dropdown/combobox. i would like to know how to use a named
range as the listfillrange. i know how to specify something like H12:H45 but
when i type the name of a named/defined range it does not work.

thanks in advance,
geebee

named range
 

Maybe

Private Sub UserForm_Activate()
For Each N In ActiveWorkbook.Names
ComboBox1.AddItem (N.Name)
Next
End Sub

ComboBox1.AddItem (N)
would add the address of the named range

ComboBox1.AddItem (N.Name) & N
would add the name and address

Mike

"geebee" wrote:

hi,

i have a form dropdown/combobox. i would like to know how to use a named
range as the listfillrange. i know how to specify something like H12:H45 but
when i type the name of a named/defined range it does not work.

thanks in advance,
geebee

named range
 

When you say "form dropdown/combobox", you mean a ComboBox on a UserForm,
right? If so, I cannot duplicate your problem... when I type the defined
Name into the RowSource property in the Properties window, it properly
assigns the defined range for that Name to the control.

--
Rick (MVP - Excel)


"geebee" (noSPAMs) wrote in message
...
hi,

i have a form dropdown/combobox. i would like to know how to use a named
range as the listfillrange. i know how to specify something like H12:H45
but
when i type the name of a named/defined range it does not work.

thanks in advance,
geebee

named range
 

if you mean in code, you have to do it like this:

Private Sub UserForm_Initialize()
Me.ComboBox1.RowSource = Range("test2").Address
End Sub


--


Gary

"geebee" (noSPAMs) wrote in message
...
hi,

i have a form dropdown/combobox. i would like to know how to use a named
range as the listfillrange. i know how to specify something like H12:H45 but
when i type the name of a named/defined range it does not work.

thanks in advance,
geebee