Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
John M
 
Posts: n/a
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.misc
kassie
 
Posts: n/a
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
combo box range - row Danny Excel Discussion (Misc queries) 0 April 18th 06 09:32 PM
Sum range auto update Dave Excel Worksheet Functions 3 April 6th 06 12:02 AM
Automatic Update from Access to EXcel Jay Excel Discussion (Misc queries) 0 February 11th 06 07:01 PM
Select cell from range based on input in excel xp dingy101 Excel Discussion (Misc queries) 3 November 20th 05 12:05 AM
Automatic Chart Update? Mike Fox Charts and Charting in Excel 7 January 6th 05 01:29 AM


All times are GMT +1. The time now is 07:01 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"