Forms Combo Box Format Control (Auto Update Range)
Forms Combo Box Format Control (Auto Update Range)
(OP)
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
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
Talk To Other Members
RE: Forms Combo Box Format Control (Auto Update Range)
the following website provides examples, among other useful information.
http://www.ozgrid.com/Excel/DynamicRanges.htm
good luck!
-pmover