Kris75
Board Regular
- Joined
- Jul 29, 2009
- Messages
- 143
Hi
I'm trying to create a holiday request card.
Sheet1 = Set up( name, team, email addresses)
Sheet2 = Leave request form
Sheet3 = a Log of all approved and Cancelled Dates
So far when inputting the the leave dates on the request form this will open a simple userform asking the user to confirm the requested dates ( txt_datefrom / txt_dateto) when clicking the command button this will send and email to an approver(identified in Sheet1) and write the dates in two columns on the Log(sheet3)
This all works great.
My managers now want me to include a peice of code that will check the requested dates in the two text boxes against those on the Log. if the dates on the user form are duplicates or fall within two time period on the log then a msg box pops up to inform the user that they have already done this.
I thought this would be simple but i cannot figure it out
Please help
I'm trying to create a holiday request card.
Sheet1 = Set up( name, team, email addresses)
Sheet2 = Leave request form
Sheet3 = a Log of all approved and Cancelled Dates
So far when inputting the the leave dates on the request form this will open a simple userform asking the user to confirm the requested dates ( txt_datefrom / txt_dateto) when clicking the command button this will send and email to an approver(identified in Sheet1) and write the dates in two columns on the Log(sheet3)
This all works great.
My managers now want me to include a peice of code that will check the requested dates in the two text boxes against those on the Log. if the dates on the user form are duplicates or fall within two time period on the log then a msg box pops up to inform the user that they have already done this.
I thought this would be simple but i cannot figure it out
Please help
