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.

    Thanks
    Attached Files Attached Files

  2. #2
    I would just use conditional formatting. Select F5:U9 and use a formula of

    =AND(F5<>"-",COUNTIF($A$5:F$9,F5)>=6)

    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
  •