Running multiple data entry forms

For cases where you need to go from one data entry form to another repeatedly, it may be useful to create a main form. The main form will display shortcut buttons to open the data entry forms for each worksheet in your workbook.

To signal that you want to create a data entry form in a specific worksheet, add the characters (+) to the beginning of the worksheet name.

Running multiple data entry forms

When clicking the button (Run All User Interfaces) the main form is executed. The automation will search all worksheet in the workbook and create a shortcut button for those whose names contain the characters (+).