Increase the list fill range with vba

[dpaton05]

How do I increase the list fill range so that when I add items to my list, a combo box that has a list of the items in it is updated automatically. The Listfillrange property of my combo box is YPNames!$A$2:$A48 but I want it to be A2 to the bottom of the list on YPNames.

 

[Michael M]

Are you still using the named range..."tblYPNames" ??
You don't need to "delete" the named range, my code in post #58 overwrites the Named range with a new one !!
BTW, it works fine for me !!

 

[Michael M]

All sorted now ???...

 

[dpaton05]

I think so

Thankyou

 

[dpaton05]

I need to sort the listbox where the names are displayed. How would I do that?

 

[Michael M]

Sort the range, the listBox will update itself.....

Sub MM1()
Range("tblYPNames").Sort Key1:=Sheets("YPNames").Range("A2"), Order1:=xlAscending, Header:=xlYes
End Sub

 

[dpaton05]

Thanks Michael.