How to run multiple Excel macros in a worksheet
We have created two macros with the names InsertLine() and InputProduct() and will demonstrate how to run the multiple Excel macros:
- The InsertLine() macro inserts a row after the headers 'Name', 'Salary' and 'Perks' row number 3.
- The InputProduct() macro helps to input data like 'Name', 'Salary' and 'Perks' through an 'InputBox' and place them in the new empty inserted row under appropriate headers above.
- The inputbox parameters can be changed to use formulas also
- A new macro is created ( NewProduct() )and has reference to the first two macros only
- Click inside this macro and then click run to execute the first two macros
The training video demonstrates the process properly.
|