sathishsusa
Member
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” & "AS" Reference name 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]”
And also highlight those days in red color in “yearly planner sheet” in input data else msgbox ” there is no overlap between those employee “ Red color which is showing only for information to look overlap if i double click on macro button it should be back to normal remove the red color.
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 “ AR” & "AS" Reference name 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]”
And also highlight those days in red color in “yearly planner sheet” in input data else msgbox ” there is no overlap between those employee “ Red color which is showing only for information to look overlap if i double click on macro button it should be back to normal remove the red color.
i attached the sample file pls check it.