Results 1 to 2 of 2

Thread: vba help

  1. #1

    vba help

    Register for a FREE account, and/
    or Log in to avoid these ads!

    I ve got the following issue. I need to make a working schedule every week. And If a person works more than 6 days in a row (for example marin in the sample data) then I want a messagebox to pop up saying - the employee(name) has reached 6 days in a row. For convenience I ve created the schedule so that you can select it in a current region. I know that a loop needs to be used.

    Attached Files Attached Files

  2. #2
    Super Moderator Bob Phillips's Avatar
    Join Date
    Mar 2011
    Excel Version
    I would just use conditional formatting. Select F5:U9 and use a formula of


    and set the format.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts