Question: 4. Write (not record) a Macro, QUESTION4, that will highlight records in blue color (ColorIndex = 5) with all employees that are either in Marketing


4. Write (not record) a Macro, QUESTION4, that will highlight records in blue color (ColorIndex = 5) with all employees that are either in Marketing or Accounting departments and those employees should have a hiring date between 1/1/1985 and 1/1/1990, both dates inclusive. (Hint: For dates, use # signs, example, #1/1/1985#) (Must use Do-Until loop). Create macro button in Database sheet. Wr NG
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
