Question: (VBA) Write a sub that uses a Do loop and an Inputbox to ask the user for a product code until a valid one is

(VBA) Write a sub that uses a Do loop and an Inputbox to ask the user for a product code until a valid one is input. A product code is valid if it starts with the letter P and are followed by four digits. For an invalid code input, it should display a message telling the user why it is invalid.

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!

6) An InputBox returns a string - whatever the user enters in the box. However, it returns a blank string if the user enters nothing and clicks on OK or on Cancel. Write a sub that uses an InputBox...

IN C++ PLEASE Topics Loops while statement Description Write a program that will compute the average of a set of decimal numbers provided by the user. The program will ask the user to enter the...

Topics C++ only! Loops while statement Description Write a program that will compute the average of a set of decimal numbers provided by the user. The program will ask the user to enter the numbers...

Notes: Use the same documentation and design rules as stated in previous assignments. This problem studies use of functions, exceptions and reading data from an input file to produce a payroll...

Please write this program in Python Code Specifications: This assignment requires user defined functions described below. No global variables are accepted. A while loop should be used to read the...

Notes: Use the same documentation and design rules as stated in previous assignments. Infinite while true loop: loops with any jump statements such as break or continue are not accepted This problem...

Please write down C++ code E.3 Modifying an Array of Integers Requirements: Write a program that allows the user to input a set of desired real number values to store in an array, and perform...

1. Modify the application so it will only customer types r and c, it should discard any extra entries on the customer line type. If the user enters a invalid code the app should display and error...

Creating a user-registration interface that implements character checks, range checks and email verification. In the blank trinket given below, write a program to get the username of a user for...

need help finishing up the code got some parts going and below the text result are the results that the prof wants and the # are what the prof is requesting Thanks again. First step, create the...

Consider a thin disk composed of two homogeneous halves connected along a diameter of the disk. If one half has density p and the other has density 2p, find the expression for the Lagrangian when the...

14. A box contains 5 red balls, 8 white balls and 7 black balls. If one ball is selected at random, calculate the probability that is white or black.

Your client created a new "WIP Inventory" account. What type and detail type must it be to appear in the dropdown asset account for inventory items? A . Assets, Current Assets B . Current Assets,...

CT Corp Comprehensive Question Canadian Tire Corporation, Limited ( Canadian Tire ) is a family of companies that includes a retail segment and a financial services division, among others. The retail...

Carefully consider the appropriate measurement methods in given situations and be conscious of their shortcomings.

Carry out an interview and review its success.

Identify the issues involved in the choices that organisations make in their relationships with their employees.