Golf Tee sheet.

Hi guys,

Im trying to create a golf tee sheet with some usefull functions.

Im having trouble working out how to do a couple of things though.

Firstly I would like to change a cell colour when a checkbox is clicked (The checkbox will be clicked when the tee time has been paid for) - that will then turn another 3 cells Green.

The other thing I know im going to have trouble with is...

I have 2 coloumns (one is for 9 hole rounds the other is for 18 hole) basicly if anything is typed into the 18hole cell for that time slot I would like the time slot exactly 2 hours ahead to be booked with the same name and also change the colour of that booking slot.

Its a bit hard to explain so I have put a link below to the excell file I have created.

Tee Sheet

Hope somone can help,

Thanks,

Chris

Chris
First of all, I would dispense with the checkboxes. The way you have
this set up you will have a fistful of checkboxes. Instead, I would use a
Worksheet_SelectionChange event macro. I would write code into that macro
to put a "P" into the Paid cell whenever a Paid cell is clicked on.
Additional code would change the colors of whatever cells you want. The
code can be written to undo all this if the user clicks on a Paid cell that
already has a "P" in it.
For the 18 hole thing I would use a Worksheet_Change event macro. That
macro would react if anything is entered into any "18" cell and do all the
things you want done. You might also consider what you want to happen if
something is put into an "18" cell for a time period that is beyond 18:56
(you don't have 2 hours left in the day). HTH Otto

"tilezzzzz" <[email protected]> wrote
in message news:[email protected]...
>
> Hi guys,
>
> Im trying to create a golf tee sheet with some usefull functions.
>
> Im having trouble working out how to do a couple of things though.
>
> Firstly I would like to change a cell colour when a checkbox is clicked
> (The checkbox will be clicked when the tee time has been paid for) -
> that will then turn another 3 cells Green.
>
> The other thing I know im going to have trouble with is...
>
> I have 2 coloumns (one is for 9 hole rounds the other is for 18 hole)
> basicly if anything is typed into the 18hole cell for that time slot I
> would like the time slot exactly 2 hours ahead to be booked with the
> same name and also change the colour of that booking slot.
>
> Its a bit hard to explain so I have put a link below to the excell file
> I have created.
>
> 'Tee Sheet' (http://www.floridabreezevillas.co.uk/1/TeeSheet.xls)
>
> Hope somone can help,
>
> Thanks,
>
> Chris
>
>
> --
> tilezzzzz
> ------------------------------------------------------------------------
> tilezzzzz's Profile:
> http://www.excelforum.com/member.php...o&userid=26335
> View this thread: http://www.excelforum.com/showthread...hreadid=396047
>