Question: I want the code in VBA in Excel PROGRAM SUBROUTINES (EXERCISES modified FROM Albright, Ch. 6 and 7) 1. CODE 1 1) Name a sheet

I want the code in VBA in Excel I want the code in VBA in Excel PROGRAM SUBROUTINES (EXERCISES modified

PROGRAM SUBROUTINES (EXERCISES modified FROM Albright, Ch. 6 and 7) 1. CODE 1 1) Name a sheet "Code Check". Create a sub btn_CheckCode1 and run it from a button in your Worksheet labeled "Enter Code #1" 2) HINT: Always SAVE before you run your code in case you end up with an endless loop!!! 3) Use an Input Box to collect an input from the user. Keep asking the user to enter a code until they enter something (make sure it isn't blank). 4) If they enter something, display a message box that says "Thank you for entering XXXX where XXXX is what they entered. s) Test with your name and put a screenshot of the message box in the sheet IV. CODE 2 Create a second button labeled "Enter Code #2". Create a sub btn_CheckCode2 2) HINT: Always SAVE before you run your code in case you end up with an endless loop!!! 3) Use an Input Box to collect an input from the user. Suppose that all valid product codes start with M and are followed by 6 digits. Keep asking the user to enter a code until they enter a validly formatted code. 4) Once they enter a valid code, display a message box that says "Thank you for entering XXXX" where XXXX is what they entered. s) Test with your name, 1234, M1234, C12345, C123456 and put a screenshot of the message boxes that output in the sheet

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!