Answer:
All the procedure is explained below step-by-step
- Press alt+F11 to open VBA in excel.
- Create a module and start entering the subroutine.
- The coding of subroutine is attached in the image.
For adding "RUN" button:
- Select a shape on the sheet for the button.(Insert > Shapes > Rectangle).
- Double click on the shape to add text and write "RUN".
- The button can be styled by adding colors and shadows.
- Now Assign macro to the button (Right click > Assign macro).
- A window pane will appear, select the macro from This workbook list so that it may work properly when shared with others.
- Press OK.
- "RUN" button has been created and by pressing it the subroutine will work as required.
