Free Excel training Videos

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:

  1. The InsertLine() macro inserts a row after the headers 'Name', 'Salary' and 'Perks' row number 3.
  2. 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.
  3. The inputbox parameters can be changed to use formulas also
  4. A new macro is created ( NewProduct() )and has reference to the first two macros only
  5. Click inside this macro and then click run to execute the first two macros
  6. The training video demonstrates the process properly.



How to run multiple Excel macros in a worksheet