Hi all,
I'm trying to make a creative and easy to use holiday planner that'll be used with the heads of departments in my office.
I so far have the general layout of how I want the worksheet to look (see images below). The calendar covers the entire year (horizontally).
and the userform for the worksheet
What I'd like to do is have a user open the userform from a button on the worksheet (not yet added), select an employee, the type of absence (holiday, sick leave or other) and add the "from" and "to" dates. When they hit submit, the userform will match the employees name from the drop down to the worksheet, note the absence type selected (which should format the target cell(s) accordingly -holiday is green, sick leave red and other blue) then find the "from date" and the "to" date and format (colour) the cells horizontally between these two dates.
I have been plugging away at this over the last day trying different types of code examples people have used for similar workbooks, but haven't the experience or skill to adjust them properly. I'm currently stuck on two things; displaying the dates correctly in the two date drop downs, and of course the submit functionality that adds to the sheet.
For the dates drop downs, i was trying the RowSource property and simply copying jan 1st to dec 31st ($C$3:$NC$3) but it doesn't display the dates correctly.. just numbers.
For the Submit button, i'm completely stumped.
If anyone can help me with either of these two problems, I'd be very grateful!
Thanks in advance.
Adam
I'm trying to make a creative and easy to use holiday planner that'll be used with the heads of departments in my office.
I so far have the general layout of how I want the worksheet to look (see images below). The calendar covers the entire year (horizontally).
and the userform for the worksheet
What I'd like to do is have a user open the userform from a button on the worksheet (not yet added), select an employee, the type of absence (holiday, sick leave or other) and add the "from" and "to" dates. When they hit submit, the userform will match the employees name from the drop down to the worksheet, note the absence type selected (which should format the target cell(s) accordingly -holiday is green, sick leave red and other blue) then find the "from date" and the "to" date and format (colour) the cells horizontally between these two dates.
I have been plugging away at this over the last day trying different types of code examples people have used for similar workbooks, but haven't the experience or skill to adjust them properly. I'm currently stuck on two things; displaying the dates correctly in the two date drop downs, and of course the submit functionality that adds to the sheet.
For the dates drop downs, i was trying the RowSource property and simply copying jan 1st to dec 31st ($C$3:$NC$3) but it doesn't display the dates correctly.. just numbers.
For the Submit button, i'm completely stumped.
If anyone can help me with either of these two problems, I'd be very grateful!
Thanks in advance.
Adam
