Please ANSWER ASAP!! Since l cant post the first part of the question it's basically asking to write VBA Macro Code in Excel prompting the user to ask for a number. PLEASE ANSWER THE FOLLOWING QUESTIONS AS THE OTHER VBA CODE ANSWERS TO THIS QUESTION ON CHEGG ARE WRONG!! Thank you in advance!!

Then the Macro should loop through the entire column of Item# which is Column D $($all $2,000+$ rows$)$ and then highlight Item# cell$($s$)$ that matches the one that is entered. You can highlight them using any clearly visible color you want.

$\backslash$table$[[4,$A$,B,$C$,$D$,$E$,F,$G$],[1,$Parent Item,Parent Quantity,Sched. Start,Item#$,$Quantity,Department,Truck Number$],[2,10074899,1,10/1/2018,10005368,1,$AerBodyset,HS $6287],[3,10074899,1,\frac{10}{1}\frac{?}{2018},10005373,1,$AerBodySet,HS$6287],[4,10074899,1,\frac{10}{1}\frac{?}{2018},10005366,1,$AerBodyset,HS$6287],[5,10074899,1,\frac{10}{1}\frac{?}{2018},10003423,1,$AerBodySet,HS $6287],[6,10074899,1,\frac{10}{1}\frac{?}{2018},10003415,1,$AerBodySet,HS $6287],[7,10074899,1,\frac{10}{1}\frac{?}{2018},10003412,,$AerBodyset,HS$6287],[8,10087800,1,\frac{10}{1}\frac{?}{2018},10046259,,$BodyBuild,HS $6287],[9,10087800,1,\frac{10}{1}\frac{?}{2018},10060279,1,$BodyBuild,HS $6287],[10,10087800,1,\frac{10}{1}\frac{?}{2018},10062984,1,$BodyBuild,HS $6287],[11,10087800,1,\frac{10}{1}\frac{?}{2018},10053970,1,$BodyBuild,HS$6287],[12,10087800,1,\frac{10}{1}\frac{?}{2018},10061472,1,$BodyBuild,HS$6287]]$

Also, because it would not be ideal for any earlier highlighting from previous searches to show up for later searches you conduct, this macro should clear out any formatting $($like highlighting$)$ before it runs each time.

For ease of viewing the results, have the macro return up to the top of worksheet again after it has completed looping through all of the rows to find cells that match the user input.

There are many different ways you can create this custom macro. You can create smaller part$($s$)$ of code that perform specific actions and then "call' these procedures in the main macro $($the procedure to clear out previous formatting might be a good one to create separately and then make a call to it in another procedure$).$ Please refer back to the lecture covering VBA and the VBA code that you created or imported in parts $1$ and $2$ of this lab to help guide you. W will be looking for $($when grading$)$ is that there is $1$ macro named Findltems which will do all of the steps outlined previously.

After creating this macro you can see how it would not be too difficult to slightly modify the code to eventually search for entries in other columns $($like Parent Item, Parent Quantity, etc.$).$ But for the purposes of this assignment, you will only need to create the macro that searches based on the entries in the Item# column $($which is Column D$).$