sathishsusa
03-14-2017, 10:51 AM
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-programming-vba-macros/1173341-highlight-and-popup-message-between-employee-dates-are-overlap.html#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.
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-programming-vba-macros/1173341-highlight-and-popup-message-between-employee-dates-are-overlap.html#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.