by defined, do you mean insert=Name=Define

Just load the 5 names in the combobox as strings

Then when the selection is made, use the value of the combobox to assign the
listfillrange of another combobox (assume that is what you want to do)

Me.Combobox2.ListFillRange =
worksheets("Data").Range(Me.combobox1.Value).Addre ss(external:=True)

Note that there are 3 different types of comboboxes (2 of which have a
listfillrange property). It is best to state what controls you are working
with.

--
Regards,
Tom Ogilvy


Scot Rundell wrote in message
...
I am tring to use a combo box to select 1 of 5 specific
list fill ranges that I have defined in another
spreadsheet. Can someone help me out with how I do this.