ZuoTi.Pro
Question

VBA coding in Excel

Write a code for the following problem:

 

“If the day of the week is Monday through Friday, then a message box is used to display the string "You should be at work!". (Remember that it had to be between 8:00 A.M. and 5:00 P.M to get to this point.) Otherwise, outputs the message "I love weekends". If the time of day is not between 8:00 A.M. and 5:00 P.M, then the string "You should not be at work!" is displayed in a message box.”


0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Request Professional Answer

Request Answer!

We need at least 10 more requests to produce the answer.

0 / 10 have requested this problem solution

The more requests, the faster the answer.

Request! (Login Required)

All students who have requested the answer will be notified once they are available.
Know the answer?
Add Answer to:
VBA coding in Excel
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Similar Homework Help Questions

  • Complete a time card for the employee below: Adam Spruce (SSN 565-56-5656) worked six days during...

    Complete a time card for the employee below: Adam Spruce (SSN 565-56-5656) worked six days during the week of 01/15/2018 through 01/21/2018 (he was off work on Tuesday). He arrived at 9:00 a.m. each day (except Friday, when he was four minutes early, and Sunday, when he was two minutes late). He left for lunch at 12:30 p.m. each day (except Wednesday, when he left at 12:28 p.m., and Thursday, when he left at 1:01 p.m.), and arrived back at...

  • PYTHON CODE First Code: Write a program that uses a text file to store the daysand...

    PYTHON CODE First Code: Write a program that uses a text file to store the daysand hours that a user worked in a week. The program should begin by prompting for the number of days worked in the week. It should continue with a loop for input of the days and hours and for writing these to the file, each on its own line. Sample Output (inputs shown in boldface) How many days did you work this week? 5 Enter...

  • The Clark County Sheriff's Department schedules police officers for 8-hour shifts. The beginning times for the...

    The Clark County Sheriff's Department schedules police officers for 8-hour shifts. The beginning times for the shifts are 8:00 a.m., noon, 4:00 p.m., 8:00 p.m., midnight, and 4:00 a.m. An officer beginning a shift at one of these times works for the next 8 hours. During normal weekday operations, the number of officers needed varies depending on the time of day. The department staffing guidelines require the following minimum number of officers on duty: Time of Day Minimum No. of...

  • Hiring a New Day Care Center Director Katie has decided to expand her day care business....

    Hiring a New Day Care Center Director Katie has decided to expand her day care business. She has one location licensed to accommodate 12 children between 6 months and 5 years old. It is open from 8:00 a.m. to 5:30 p.m. Monday through Friday. Many of her customers have been asking for Saturday and extended hours. In addition, she has a waiting list of seven children. Finally, the local military base is about to add 5,000 new jobs, so Katie...

  • THIS CODE SHOULD BE MODIFIED TO READ SuperMarket.dat instead of Inputting and Outputting. SuperMarket.dat Monday 4...

    THIS CODE SHOULD BE MODIFIED TO READ SuperMarket.dat instead of Inputting and Outputting. SuperMarket.dat Monday 4 Monday 6 Monday 2 Tuesday 3 Tuesday 2 Wednesday 3 Wednesday 5 Wednesday 7 Thursday 5 Friday 4 Friday 3 Friday 4 Saturday 8 Saturday 8 Saturday 8 Sunday 0 QUESTION: Write the control break code, including the code for the dayChange() method, in the main() method. // SuperMarket.java - This program creates a report that lists weekly hours worked // by employees of...

  • need help with this JAVA lab, the starting code for the lab is below. directions: The...

    need help with this JAVA lab, the starting code for the lab is below. directions: The Clock class has fields to store the hours, minutes and meridian (a.m. or p.m.) of the clock. This class also has a method that compares two Clock instances and returns the one that is set to earlier in the day. The blahblahblah class has a method to get the hours, minutes and meridian from the user. Then a main method in that class creates...

  • 2) Clifftown’s Parks and Recreation Department is introducing a new summer day camp for children in...

    2) Clifftown’s Parks and Recreation Department is introducing a new summer day camp for children in elementary school, providing programming from 8:00 a.m. to 5:00 p.m. Monday through Friday. The proposed day camp program is 10 weeks long and is planned for 50 children. Fixed costs include staff, equipment, and facilities costs, and the total fixed cost is estimated at $15,000 for the 10 weeks. The camp will serve lunch and snacks each weekday at a weekly cost of $15...

  • Project Schedules and Scheduling Tools In this assignment, you will create a schedule for the month...

    Project Schedules and Scheduling Tools In this assignment, you will create a schedule for the month of December of this year for your team members—John, Sally, Pedro, and Eunice. While creating the schedule, keep in mind the following conditions: Every employee in the company needs to work for 45 hours per week. John works from Saturdays to Wednesdays in the 6:00 a.m. to 4:00 p.m. shift, with a 1-hour lunch break. Sally works from Mondays to Thursdays in the 3:00...

  • Microsoft Excel VBA (Visual Basic for Applications) Programming Language Objectives: Create an array and redim it...

    Microsoft Excel VBA (Visual Basic for Applications) Programming Language Objectives: Create an array and redim it to a size equal to an assigned value of a variable, populate the array with a series of random numbers, output the array to a message box and to a worksheet. Instructions: - Review the variables already declared. You won't need others. - See comments in the code that will act as your guide. Add new code directly after each comment. - Assign a...

  • a C++ program that computes the cost of a long-distance call. The cost of the call...

    a C++ program that computes the cost of a long-distance call. The cost of the call is determined according to the following rate schedule: a. Any call started between 8:00 A.M. and 6:00 P.M., Monday through Friday, is billed at a rate of $0.40 per minute. b. Any call starting before 8:00 A.M. or after 6:00 P.M., Monday through Friday, is charged at a rate of $0.25 per minute. c. Any call started on a Saturday or Sunday is charged...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT