Help with VBA outlook appointment start/end time question

[lilsnoop]

Hello,

I found the following vba code which will create an outlook appointment, but I need to be able to set the start and end time, which would be a set value (i.e. 8:30am for start time and 9:00am for end time). Can anyone assist me with adding this component to this existing code? I would be very grateful.

Please Login or Register  to view this content.

Thank you!

[Richard Buttrey]

What's the value in S1?

Is it just an integer date number? If so then

Please Login or Register  to view this content.

[lilsnoop]

Richard Buttrey

I have this in cell S1

Please Login or Register  to view this content.

Thank you for the assistance! Your suggestions worked as requested!

Appreciate the assistance!