Combo Box - ListFillRange - With Named Range

[SanAntonioSpurFan]

I have a combobox that gets its value from a named range. Named range is called SegRange. I typed in SegRange in the properties section for ListFillRange and it works perfect until you add another value to the range. For Example:
SegRange = C1:C4 - I used a offset function with a countA function included to always adjust the range for new values. That part works. When C5 gets a value, the SegRange name shows it but the combo box does not adjust its property to include it automaticly. If I type the name "SegRange" into the ListFillRange again, it works. Is there a way to have it update automaticly?

 

[SkipVought]

SanAntonioSpurFan,

You need to make your List DYNAMIC. Check out the options in my FAQ:

faq68-1331 How can I rename a table as it changes size



Skip,

http://www.TheOfficeExperts.com

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

 

[SanAntonioSpurFan]

I just noticed that you can write a procedure that will update the datasource on click....

Private Sub SelectedSegment_DropButtonClick()
SelectedSegment.ListFillRange = "SegRange"
End Sub

Works Great...