Combo Box input range automatic update
 

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

Combo Box input range automatic update
 

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

"John M" wrote:

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