Hi, I am wondering if it is possible to have a ComboBox with rowsource= Locations (Dynamic Named Range) that will refresh if another location is added on the range. Currently on the UserForm (UF1) there is a command button which will open a second UserForm (UF_AddLocation) which has the user add additional info for this new location (only the title is in the Dynamic Named Range). The ComboBox's (UF1.CB_Location) list Only shows what was in the dynamic range when the UserForm was opened. I have looked for a while and hope one of you may have the answer. Is there any way to have this refresh without having to close the form and lose all the other data entered? Thanks
Bookmarks