MobileMobile | Continue

Excel Bar

Excel Bar

Your excel questions will be responsed by our excel experts within 24hrs.Our service is free.

 Forgot Pass?
 Register Now
Find
Hot Search: Vlookup Match VBA
12Next
Return Post new threads
View: 533|Reply: 13

Highlight and popup message Between employee dates are over

[Copy link]

6

Topics

27

Posts

82

Integral

Member

Rank: 2

Integral
82
Post on 2-9-2017 19:06:51 | All posts |Read mode
Hi,
     I need the vba code for leave planning can u help me out to solve .
     Highlight and popup message to show the overlap dates  by each months between two or three employees by selecting check box  in column “ AR” search from whole year (January to December ) calendar.
     Once overlap days are there between employees then msgbox  should appear like
                                                    ” overlap between those employees
                                                    Employee01  from  [ date] to [date]
                            Employee02  from  [ date] to [date]
                                                    Employee04  from  [ date] to [date]”  vbok and cancel button
And also highlight those days in red color in “yearly planner sheet”   in calendar else msgbox  ” there is no overlap between those employee “ with  vbok and cancel button.
i attached the sample file pls check it.








  • Leave Planner - solution.xlsm
    (102.5 KB, 0 views)
    Download

  • Reply

    Props Report

    15

    Topics

    1390

    Posts

    2971

    Integral

    King

    Rank: 6Rank: 6

    Integral
    2971
    Post on 2-10-2017 06:40:36 | All posts



    In simple way, using conditional formatting also possible. plz ref attach file.








  • Leave Planner - solution.xlsm
    (97.1 KB, 2 views)
    Download















  • Reply Support Opposition

    Props Report

    6

    Topics

    27

    Posts

    82

    Integral

    Member

    Rank: 2

    Integral
    82
     Author| Post on 2-10-2017 07:21:44 | All posts



    Hi AVk,
    Thanks for your reply but i need to select by choose to compare the overlap between what i choose the employees in column AR  not for all employee to compare to highlights in red colur. if i select in check box i can choose either employee01  employee04 or employee01  employee02 or employee01  employee03  employee04 that time to check overlap between what i selecting the employee in column AR. but highlighting in column in red colur is nice. what i need is still didnt got, so i think vba code can possible for this changes to get....
    Reply Support Opposition

    Props Report

    15

    Topics

    1390

    Posts

    2971

    Integral

    King

    Rank: 6Rank: 6

    Integral
    2971
    Post on 2-10-2017 09:12:43 | All posts



    In simple way, using conditional formatting also possible. plz ref attach file.








  • Leave Planner - solution.xlsm
    (97.1 KB, 4 views)
    Download















  • Reply Support Opposition

    Props Report

    6

    Topics

    27

    Posts

    82

    Integral

    Member

    Rank: 2

    Integral
    82
     Author| Post on 2-10-2017 10:18:49 | All posts



    Hi AVk,
    Thanks for your reply but i need to select by choose to compare the overlap between what i choose the employees in column AR  not for all employee to compare to highlights in red colur. if i select in check box i can choose either employee01  employee04 or employee01  employee02 or employee01  employee03  employee04 that time to check overlap between what i selecting the employee in column AR. but highlighting in column in red colur is nice. what i need is still didnt got, so i think vba code can possible for this changes to get....




    Reply Support Opposition

    Props Report

    15

    Topics

    1390

    Posts

    2971

    Integral

    King

    Rank: 6Rank: 6

    Integral
    2971
    Post on 2-10-2017 11:30:43 | All posts



    Then range applies to : AR8 to AR11 in CF









    Reply Support Opposition

    Props Report

    6

    Topics

    27

    Posts

    82

    Integral

    Member

    Rank: 2

    Integral
    82
     Author| Post on 2-10-2017 11:47:04 | All posts



    i tried by selecting the check box but what i need it not getting results i tried in three choice to compare the overlap dates but it not working between those three employees and if says cancel i don't want to show back in red color it should turns normal. the overlap dates i need only an information to highlight after that i want it back in normal.
    Reply Support Opposition

    Props Report

    15

    Topics

    1390

    Posts

    2971

    Integral

    King

    Rank: 6Rank: 6

    Integral
    2971
    Post on 2-10-2017 10:09:22 | All posts



    In simple way, using conditional formatting also possible. plz ref attach file.








  • Leave Planner - solution.xlsm
    (97.1 KB, 6 views)
    Download















  • Reply Support Opposition

    Props Report

    15

    Topics

    1390

    Posts

    2971

    Integral

    King

    Rank: 6Rank: 6

    Integral
    2971
    Post on 2-11-2017 18:19:24 | All posts



    In simple way, using conditional formatting also possible. plz ref attach file.








  • Leave Planner - solution.xlsm
    (97.1 KB, 8 views)
    Download















  • Reply Support Opposition

    Props Report

    6

    Topics

    27

    Posts

    82

    Integral

    Member

    Rank: 2

    Integral
    82
     Author| Post on 2-11-2017 21:01:52 | All posts



    i tried by selecting the check box but what i need it not getting results i tried in three choice to compare the overlap dates but it not working between those three employees and if says cancel i don't want to show back in red color it should turns normal. the overlap dates i need only an information to highlight after that i want it back in normal.










    Reply Support Opposition

    Props Report

    12Next
    Return Post new threads

    Points policy of this forum

    Archiver|Mobile|Small dark house|Contact us|Excel Bar

    GMT-5, 11-19-2017 16:16 , Processed in 0.249128 second(s), 20 queries .

    Powered by Discuz! X3

    © 2001-2013 Comsenz Inc.

    !fastreply! Top !return_list!