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