Right...
I've kinda hit another brick wall with my wonderful checkout holiday tracker...
With some help, we can look-up which weeks are free etc. So now, I need to go to the next step.
What I need to do next is, when a week is closed, set up a message where it says "you must choose another week"
And when a week is open, I'd like it to to set up an input form, where you can enter a name, and the days that they want to book off. Then have this info update on the schedule.
The idea would be that only 5 people can book holiday for each week, so after the 5th person books off the same week, the week automatically becomes closed to all others.
But I really don't know where to start with making forms, or doing this auto-closing function.
The form would need to take in to account
- the colleague's name
- which days of the week they want off
- how many hours each day they have booked off
Can anyone get their head around that for me at all?
Thanks
The most up-to-date copy of the file is attached below
Your post does not comply with Rule 5 of our Forum RULES. We have Seven question forums: Miscellaneous, General, Programming, Worksheet Functions, Charting, Excel 2007 Help and New Users. Please choose the appropriate forum, and post your question in ONLY one forum.
Moved to Programming
Hope that helps.
RoyUK
--------
If you are pleased with a member's answer then use the Star icon to rate it, if you are pleased enough to part with cash consider a donation to Children in Need
For Excel consulting, free examples and tutorials visit Excel Consulting-Excel VBA
Check out the free Excel Toolbar
New members please read & follow the Forum Rules
Remember to mark your questions Solved and rate the answer(s)
Code Tags: Make your code easier for us to read
Apologies, I wasn't sure if it was a programming question or not.Originally Posted by royUK
Thanks for the clarification
Hopefully someone will be able to solve this one for me again.
EDIT: If you can see the attachment below, I've sorta made a rough draft of what I'm after on the "book new holiday" page. However, I haven't for the foggiest where to start to build something like that!
Last edited by monkey90; 03-20-2010 at 12:41 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks