Question: Write a VBA program (consisting of a single subroutine) to check existence of a given value in a list. Specifically, you are given a list

Write a VBA program (consisting of a single subroutine) to check existence of a given value in a list. Specifically, you are given a list of product IDs in column A, as follows: 1 Product ID 2 A-237 3 C-17 4 G23990 5 AB-447

You do not know how many products there are. The user inputs the value and code checks this against the list and returns a message box stating if product exists, was found or not found.

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 General Management Questions!

Q 1 . Write a reference, in VBA code, to each of the following ranges. ( You can assume that each of these ranges is in the active worksheet of the active workbook, so that you don t have to qualify...

Please help with questions on page 14 assignment 01 - urgently need help tonight DSC2604/101/3/2016 Tutorial letter 101/3/2016 Financial Modelling DSC2604 Semesters 1 & 2 Department of Decision...

Exam 3-Scaling Up with VBA Learning Objective: In this assignment, you will use your recently acquired knowledge of Excel VBA coding to scale up the analysis from the previous exercise. You should be...

There are two problems due this week (each worth 35 points) as follows. Problem 1.6 (page 20) In comprehensive paragraphs, answerrequirements a to e. You will have 5 paragraphs total of four to five...

Write a C program to execute a deadlock detection program One technique for dealing with deadlock is called detect and recover. In this scheme, some procedure is used to identify when a deadlock...

Written in Java. Please help. Any information would be greatly appreciated. Even shelling of the code would be beneficial if you cannot understand the whole thing. Thank you!!!!!!!!!!!!!!!!!! Example...

I highly recommend that you DO NOT use threads! In the past, students unknowingly have created around 200 threads which of course causes the system to kill your programs. You will submit your source...

Need help filing out the Form 706 that goes along with the Estate Tax Problem. Specifically, what is the amount entered in line 10, part 5 of the Form 706? Estate\tTax\tProblem...

In this question assume that p and q are atomic formulae. (a) Compare and contrast path formulae and state formulae in temporal logic. [4 marks] (b) Describe and contrast the meanings of F(G p) and...

The XYZ Corporation determines it can make a real (inflation-adjusted) return on an investment of 6 percent. The nominal rate of interest is 11 percent and the rate of inflation is 4 percent. We can...

Indirect, undistributed costs of $14,000 are to be allocated to two departments, department one occupies 54% and department 2 occupies 46% of the total square footage available. Calculate the amount...

Devon is an aspiring businessman. He wants to set up a petrol station and electric vehicle charging station in his neighbourhood. The area is growing and has a small shopping centre on the main road...

Case Greenbuilders Pte Lid ("GPL") is a local construction company which specialises in providing bespoke Design and Build construction services for private residential homes that are designed to be...