Hi everybody.
I have an activex combobox filled with a dynamically named range. Rhe listfill range in the combobox has the range name in it. If I add values to the bottom of the range it does not show in the activexcombobox drop down, unless I retype the same name again in the listfill range box?? If I save the sheet nothing happens but if i save and close and reopen the sheet the added values at the bottom of the list is there? Thanks a lot.
I have an activex combobox filled with a dynamically named range. Rhe listfill range in the combobox has the range name in it. If I add values to the bottom of the range it does not show in the activexcombobox drop down, unless I retype the same name again in the listfill range box?? If I save the sheet nothing happens but if i save and close and reopen the sheet the added values at the bottom of the list is there? Thanks a lot.