Question: Record a macro, QUESTION2, that will ask the user to input the hiring date (using inputbox function) and then calculate number of employees hired on

 Record a macro, QUESTION2, that will ask the user to input
the hiring date (using inputbox function) and then calculate number of employees

Record a macro, QUESTION2, that will ask the user to input the hiring date (using inputbox function) and then calculate number of employees hired on or after that hiring date (e.g., user will input dates such as ">=2/1/1995")? Set up criteria on Queries worksheet, and answer should be on Queries sheet in the cell indicated. Create macro button on Queries sheet. Macro should be self-sufficient including first clearing the criteria range. Create macro button Query worksheet. 3. Record a Macro, QUESTION3 that will change all the records to the font color RED. Create macro button in Database 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 Finance Questions!