Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 561
  • Last Modified:

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.
gary2.xls
0
Kiwi-123
Asked:
Kiwi-123
  • 2
  • 2
1 Solution
 
Elton PascuaCommented:
Here's a partial (works with March to August dates) solution. Is this what you were looking for?
code-appt-time-frames.xls
0
 
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!
0
 
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.
code-appt-time-frames.xls
0
 
Kiwi-123Author Commented:
Fantastic, many thanks for your help!
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now