Updating Lookup List for Combo Box

[Neil]

Hi All,

I'm using a Combo Box (from the control toolbox) to limit user input to a
list of values, these values being defined in a dynamic named range.

Currently, if I add entries to the dynamic named range, these are not
updated into my combo box.

How can I force an update of the DNR each time I use the combo box ??

Thanks for your assistance.

Neil

 

[DJH]

Set your Name for the list to equal

=OFFSET(Sheet1!$A$1,0,0,COUNTA(Sheet1!$A:$A),1)

 

[Neil]

Thanks DJH,

I've already got this equation set up - the Dynamic Named Range updates just
fine when I add data to my list, this update is not reflected in the combo
box though.....

This is where I need some assistance.

Regards,

Neil