Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calendar problem
I have a dialog box which contains 4 Calendars. The 4 calendars are set up
so that when you click on the 2nd or 4th Tuesday of the first calendar the other calendars would progressively show the next Tuesday which was 2 weeks away, see code below. It turns out that what I need to have happen, is that if I select the 2nd Tuesday (say of September) on Calendar1 then Calendar2 should have the 4th Tuesday of September selected, Calendar3 the second Tuesday of October and Calendar4 would display the 4th Tuesday of October. Of course if I had started with the 4th Tuesday of September the I would need the 2nd Tuesday of October and so on. So it is obvious my code can not do this, so does anyone have an idea how I might make this work? Private Sub Calendar1_Click() Calendar2 = Calendar1 + 14 Calendar3 = Calendar1 + 28 Calendar4 = Calendar1 + 42 End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
find free sharware to include calendar pop or use calendar in cell | Excel Discussion (Misc queries) | |||
how do i export excel calendar info to outlook calendar? | Excel Discussion (Misc queries) | |||
import calendar items from excel into outlook calendar | Excel Discussion (Misc queries) | |||
Calendar Problem- What's Wrong? | Excel Discussion (Misc queries) | |||
Calendar object in Excel problem - mscal.ocx | Excel Programming |