Forms Combo Box Format Control (Auto Update Range) 1

[d23]

I am using a combo box from the “FORMS” toolbar. In the format control where you select the input range is there a way to automatically update the range?

I would like to write a series of “IF” statements that will determine the number of rows selected in the box. This selection will be determined base on several other inputs. As an example I may want to select A1:A10 for my first run, but as the input data changes I may need to select A1:A20.

I need the info to automatically update. Is there a way to do this without a macro?

Thanks!
D23

 

[pmover]

try what is called a "dynamic range".

the following website provides examples, among other useful information.

http://www.ozgrid.com/Excel/DynamicRanges.htm

good luck!
-pmover