VB Help

Please can you help with the attached workbook.

On sheet 1 "Data Input" I have a list of dates which I will enter-

The date + time of appointment

I want to add a vb command button so that it will convert the dates and then highlight the relervant sections upon the two calenders "March - August 2012" & "September 2012 - February 2013".

In column F sheet 1 I hope to use the listed colour code, so it will be possible to use different colours to highlight.

Any dates outside those listed (+ colour code) I'd like to keep as is on the two calenders.

Many thanks for your help, this is not easy because the calenders have intervals of 15 mins. So if a appointment was for 14 mins for example, none of the indivdual segments would be highlighted. If it was for 15, then just one would be.
Who is Participating?
Elton PascuaCommented:
Try this one. The macro automatically clears all the cells before inputting the date fills. This should now work with both sheets.

I've placed comments in the code for better understanding.
Elton PascuaCommented:
Here's a partial (works with March to August dates) solution. Is this what you were looking for?
Kiwi-123Author Commented:
Hi Techfanatic,

Many thanks for your help, the example is exactly what I was looking for. Is there a chance I can extend this onto "September 2012 - February 2013".

If the date was removed/amended on sheet 1, would it be possible for the code to place the affected cells in their orginal state.

Thanks again!
Kiwi-123Author Commented:
Fantastic, many thanks for your help!
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.