Adding and Removing Input and Output Variables
The default setting for all advanced controls is one output variable and no input variables. In the default case, the control only responds when values are changed in it, not in other worksheet variables. The number of input values is limited only by your system resources.
Adding Input Variables
1. In the worksheet, right-click the control.
2. Choose Add inputs.
3. A placeholder appears above the control. In this placeholder, enter the data for your new input. This data can include numbers, arrays, strings, or other expressions that produce one of these values.
• You can add multiple input variables to the control using the Matrices/Tables tab.
◦ To add one variable at a time, select Insert Left or Insert Right.
◦ To add a matrix of input variables, select Insert Matrix.
Removing Input Variables
• To remove an input variable, navigate to navigate to the Matrices/Tables tab, the Rows and Columns group, and select Delete Column.
• To remove the entire input section, right-click the control and choose Remove inputs. This option will remove the input section along with all the variables defined in it.
Adding Output Variables
1. Click the output section of the control, click > > .
2. Select the size of the output array and click.
3. Type the names of the outputs in the placeholders of the output array.
Removing Output Variables
To remove a row or a column of output variables, navigate to the Matrices/Tables tab, the Rows and Columns group, and select Delete Rows or Delete Columns.