E
Ed from AZ
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
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