Question: Please make a VBA like we did in the class. When the room number is less than 5 0 , the faculty should work on

Please make a VBA like we did in the class.
When the room number is less than 50, the faculty should work on Monday.
When the room number is greater than 50 and less than 100, the faculty should work on
Tuseday.
When the room number is great than 50 and less than 150, the faculty should work on
Wednesday.
When the room number is greater than 50 and less than 200, the faculty should work on
Thursday.
For other number, the faculty work on Friday
You should use two ways to write the code. One is nested if structure that we did in the class.
Another is If.
else if
end if without nested structure.
 Please make a VBA like we did in the class. When

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!