Combo Box input range automatic update

J

John M

How do I update the Combo Box control input range automatically? When the
iniput range refers to a list and a row in the list is deleted the input
range is reduced but when a row is added to the list the input range is not
changed. Is there a way to automatically update the input range
 
K

kassie

Do Insert|Name|Define and give your range a name. Insert rows within the
range, ie between the first and last rows, not before the first or after the
last, and it should pick up the additions
 
Top