Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
combo box range - row | Excel Discussion (Misc queries) | |||
Sum range auto update | Excel Worksheet Functions | |||
Automatic Update from Access to EXcel | Excel Discussion (Misc queries) | |||
Select cell from range based on input in excel xp | Excel Discussion (Misc queries) | |||
Automatic Chart Update? | Charts and Charting in Excel |