Prev Previous Post   Next Post Next
  #2   Report Post  
Andy Brown
 
Posts: n/a
Default

"Dewayne" wrote in message
...
I use a combo box on 1 worksheet and reference an input range from another
worksheet in the same workbok. The length of the input range continues to
expand forcing me to increase the rows of the input range. I have been
unable to do this by editing the combo box input range. I have been

deleting
the box, inserting a new box in the same cell and redefining the input

range
at that time.
Is there a way to edit (expand) the input range referenced by a combo box
rather than starting at the begining each time?


See http://www.contextures.com/xlNames01.html#Dynamic.


 
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
extract data from combo box n use it in SQL benj Excel Discussion (Misc queries) 2 February 16th 05 09:54 AM
"Combo Box - getting control combo box to stick in place in worksh ajr Excel Discussion (Misc queries) 1 February 16th 05 02:05 AM
"Combo Box - getting control combo box to stick in place in worksh ajr Excel Discussion (Misc queries) 0 February 15th 05 07:45 PM
dynamic combo boxes tjb Excel Worksheet Functions 2 January 25th 05 07:33 PM
How do I autofill combo boxes with their destination cell? Defoes Right Boot Excel Worksheet Functions 3 January 10th 05 12:49 PM


All times are GMT +1. The time now is 10:05 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"