Results 1 to 3 of 3

Thread: Highlight and popup message Between employee dates are overlap using (vba)

  1. #1
    Junior Member
    Join Date
    Mar 2017
    Posts
    14
    Rep Power
    0

    Post Highlight and popup message Between employee dates are overlap using (vba)

    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 " AS" compare the Column at ' C & D '
    Once overlap days are there between employees then msgbox should appear like
    " overlap between those employees
    Employee01 from [ date] to [date]
    Employee03 from [ date] to [date]
    Employee04 from [ date] to [date]" vbok and cancel button
    And also highlight those overlap days in red color in "yearly planner sheet" in column 'F' overlap header

    else msgbox " there is no overlap between those employee " with vbok and cancel button.

    https://www.excelforum.com/excel-pro...ml#post4587536

    the above thread has not been solved for while a month ago i waited long time but no response. Excel experts can u have a look on it pls

    i attached the sample file pls check it.
    Attached Files Attached Files

  2. #2
    Fuhrer, Vierte Reich DocAElstein's Avatar
    Join Date
    Aug 2014
    Posts
    9,270
    Rep Power
    10
    ….If you are my competitor, I will try all I can to beat you. But if I do, I will not belittle you. I will Salute you, because without you, I am nothing.
    If you are my enemy, we will try to kick the fucking shit out of you…..
    Winston Churchill, 1939
    Save your Forum..._
    _...KILL A MODERATOR!!

  3. #3
    Junior Member
    Join Date
    Mar 2017
    Posts
    14
    Rep Power
    0
    Many thanks to Mr.Alan you rocking...

Similar Threads

  1. Insert Missing Dates By Comparing Two Lists Of Dates
    By mahmoud-lee in forum Excel Help
    Replies: 24
    Last Post: 10-16-2013, 04:48 PM
  2. Highlight Current Row in Excel (VBA)
    By Admin in forum Excel and VBA Tips and Tricks
    Replies: 16
    Last Post: 07-31-2013, 06:46 AM
  3. How to Extracting dates and days between 2 dates.
    By Rajesh Kr Joshi in forum Excel Help
    Replies: 9
    Last Post: 08-11-2012, 09:11 PM
  4. High Lighting Current Date In employee Attendance
    By sanjeevi888 in forum Excel Help
    Replies: 2
    Last Post: 07-01-2012, 10:59 PM
  5. Replies: 2
    Last Post: 12-12-2011, 01:51 PM

Posting Permissions

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