named range

[geebee]

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

 

[Mike H]

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

 

[Rick Rothstein]

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.

 

[Gary Keramidas]

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

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