I'm having a beginner VB moment.
How come I can call a named range to fill my ComboBox, but I can't just use the same code that I used to get the name with in the first place?
(XP, Control CB on wksht calling list from another wksht)
Thanks for any corrections.
Don
Private Sub ComboBox1_DropButtonClick()
ComboBox1.ListFillRange = "CAList" 'Why does this work...
'And not this??
'ComboBox1.ListFillRange = Sheets("ListPage").Range("D4", Range ("D65536").End(xlUp)).Address
'or this??
'ComboBox1.ListFillRange = Sheet8.Range("D4", Range ("D65536").End(xlUp)).Address
'or other similar attempts?
End Sub
How come I can call a named range to fill my ComboBox, but I can't just use the same code that I used to get the name with in the first place?
(XP, Control CB on wksht calling list from another wksht)
Thanks for any corrections.
Don
Private Sub ComboBox1_DropButtonClick()
ComboBox1.ListFillRange = "CAList" 'Why does this work...
'And not this??
'ComboBox1.ListFillRange = Sheets("ListPage").Range("D4", Range ("D65536").End(xlUp)).Address
'or this??
'ComboBox1.ListFillRange = Sheet8.Range("D4", Range ("D65536").End(xlUp)).Address
'or other similar attempts?
End Sub