PP 11.1 – Write a program that creates an exception class called StringTooLongException, designed to be thrown when a string is
discovered that has too many characters in it. In the main driver of the program, read strings from the user until the user enters "DONE". If a string is entered that has too many characters (say 20), throw the exception. Allow the thrown exception to terminate the program.
1 answer:
You might be interested in
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.
