You are defining a worksheet level name, that will only be visible in the
names box on its own sheet. You can use it in other sheets by prefixing
like this

='Sheet name'!theName

the apostrophes may be required if there is punctuation or some other
characters like a space in the sheet name.

You should be able to use in a listbox on other sheets by prefixing as above

You can't refer to other sheets in a DV list but you can work around like
this -
=INDIRECT("sheet1!theName")

Regards,
Peter T


"Ed from AZ" wrote in message
...
In XL 2007, I'm naming ranges using
nm = wks.Name
a = a - 1
rg = wks2.Range(Cells(21, b), Cells(a, b))
wks2.Names.Add _
Name:=nm, _
RefersTo:=rg, _
Visible:=True

I can see them in the Name Manager, but I can not see them in the
Names box (upper left), nor can I reference them as a Data Validation
source or a ListBox source.

What I really want to do is use two ListBoxes, with LB2 taking its
reference from the selection of LB1. I found this from Debra
Dalgleish:

Create a change event for ListBox1, with code similar to the
following:

Private Sub ListBox1_Change()
ListBox2.ListFillRange = ListBox1.Value
End Sub

but I can't get the ListBox I created on the worksheet to accept the
named range as a source!!

Can someone help me make sense of this?

Ed