Where is it used?
Identifies the recipe step or Split Flow branch, such as 3. filter.
MorphoGrid VBA · editable inputs
Change the business values. Keep the automation.
Generated VBA creates a MorphoGrid Parameters sheet so filters, row counts, replacement values, output names and other inputs can change without generating and importing a new BAS file.
The simple rule
Edit yellow cells in “Editable value.”
The other columns explain where each value is used and preserve the generated default. The internal key column is hidden because it belongs to the macro.
What does it control?
Column, Operator, Value, Row count, Output filename, Format, or Enabled.
This is the working value.
Change this yellow cell. The macro reads it when processing begins.
Your safe reset point.
The original exported value. Restore defaults copies it back when requested.
Worked example
Change “Status equals Open” to “Status equals Closed.”
The saved recipe keeps open claims. This month you need identical cleanup and output logic, but only for closed claims.
StepSettingEditable valueTypeGenerated default
3. filterEnabledYesYes/NoYes
3. filterCondition · columnStatusColumnStatus
3. filterCondition · operatorequalsOperatorequals
3. filterCondition · valueOpen ClosedTextOpen
BEFOREStatus equals Open
→The generated default stays visible.
AFTER EDITStatus equals Closed
The next run keeps closed records. No new BAS is required.
Safe update sequence
Five steps before processing the next file.
- Open workflow inputs.From MorphoGrid Control, click Edit workflow inputs.
- Find the step and setting.Use the visible Step and Setting columns. Do not alter the hidden key.
- Edit the yellow value.Enter the new filter, row count, filename, column, format, or Yes/No state.
- Click Validate inputs.Invalid numeric or Yes/No cells turn red and should be corrected.
- Run automation.Select the source, then verify the output and run log as usual.
Filter
Switch region or status
Change Condition · value. Keep operator names such as equals, contains, between, or greaterOrEqual.
Remove rows
Accommodate a later header
Change Row count from 3 to 5 when the actual header moves from row 4 to row 6.
Replace or fill
Change business terminology
Update Find, Replacement, or Value without rebuilding the surrounding cleanup.
Split Flow
Rename outputs or routes
Change a branch value or filename. Unique splits also expose column and format.
What the table is not
A parameter panel, not a workflow editor.
Tune existing inputs and turn generated steps on or off. To add, delete, reorder, or restructure steps and nested groups, update the workflow in MorphoGrid and export a fresh BAS.
- Do not rename the MorphoGrid Parameters sheet.
- Do not modify or duplicate hidden keys.
- Use exact incoming header spelling.
- Test important changes on a disposable sample.
- Restore defaults discards all edited values.
Troubleshooting
If a changed parameter does not work.
The macro says a column is missing.
The Column value must match a header available at that point in the recipe. Check spelling and earlier rename steps.
A numeric field turns red.
Enter digits rather than words: use 5, not “five rows.”
I disabled a step but still see it.
That is expected. Set Enabled to No to skip it; the row remains so it can be enabled later.
How do I undo every edit?
Click Restore defaults and confirm. Editable values return to their generated defaults.
Does Reset and run delete inputs?
No. MorphoGrid preserves the Parameters sheet during normal reset-and-rerun operations.
Can I manually add another filter row?
No. Add the condition in MorphoGrid and export again so the matching procedure is compiled.
One module. Many routine variations.
Update the values, validate, and run again.
Use MorphoGrid again when the workflow structure itself needs to evolve.