View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Patrick Simonds Patrick Simonds is offline
external usenet poster
 
Posts: 258
Default Calendar Control

Not sure where my post went but I cant see it so sorry if this is a
duplicate of sorts.

I asked how to make a Calendar control (on a dialogbox) open with today's
date. I figured that out:

Calendar1.Value = Now()

But what I need it to do is display the date of the next Tuesday 2 weeks
from today. Hope that makes sense.

Examples:

Today is Friday 21 June date selected on the Calendar control should be 4
July,
Today is Sunday June 25 date selected on the Calendar control should be 11
July