|
186
|
How do I change the color to display the marked-dates (EBN-color)
With Calendar1
.BeginUpdate
.Date = #1/17/2001#
.SelDate = #1/19/2001#
.AutoSize = exFixedSize
.FixedCellWidth = 24
.FixedCellHeight = 24
.AlignmentDay = CenterAlignment
.VisualAppearance.Add 1,"gBFLBCJwBAEHhEJAAEhABE8GACAADACAxRDgMQBQKAAzQFAYbBlBaERiGQYIJhUAIIRZGMIlVBJNw1DCNIDAWCQCgkNA1STAcLySAAchhEAZAIhGQHfiGNoqRDMczxN" & _
"BgARZE6QILkaYJAjuNgyTjAdC0NIkTBrIKQBomCTKMhqSI4UpVM6RCKoSx6GSuZ5GUYKegmY5lVpVVIxPZNGwHE6WJThGTpQiOWYDC4LTS2bS4AT7JabZ5nej4JoKb5E" & _
"WzGN63fhMfSdKChYhqTDcLjrCZfWDXFoABY9RTJHrGb6tPAKMwOcQ2VLZQxyBKmKZHLSQMwzOwMbx2ZpkXZbF4XVbmX4TUyIdQyLSpMy3CaVXbTGw5VqWPZrXDLAAvG5" & _
"dieEY6jacx5hsfh+G4K4ThudY1hOPgsCYX5lkQVg5DMXg+nqWgGkKDAsgKUYXj4CZxBKfJ9BoLoPE8e5pGkGgTi2IBAlAECAg"
.Background(exMarkerColor) = &H1000000
.Events.Add(Calendar1.Date).Marker = True
.EndUpdate
End With
|
|
185
|
How do I change the color to display the marked-dates (solid-color)
With Calendar1
.BeginUpdate
.Date = #1/17/2001#
.SelDate = #1/19/2001#
.AutoSize = exFixedSize
.FixedCellWidth = 24
.FixedCellHeight = 24
.AlignmentDay = CenterAlignment
.Background(exMarkerColor) = &H7f0000ff
.Events.Add(Calendar1.Date).Marker = True
.EndUpdate
End With
|
|
184
|
How do I change the color to display the marked-dates (line-color)
With Calendar1
.BeginUpdate
.Date = #1/17/2001#
.SelDate = #1/19/2001#
.AutoSize = exFixedSize
.FixedCellWidth = 24
.FixedCellHeight = 24
.AlignmentDay = CenterAlignment
.Background(exMarkerColor) = RGB(255,0,0)
.Events.Add(Calendar1.Date).Marker = True
.EndUpdate
End With
|
|
183
|
ImageSize property on 32 (specifies the size of the control' icons)
With Calendar1
.BeginUpdate
.ImageSize = 32
.Font.Size = 16
.FixedCellWidth = 72
.FixedCellHeight = 44
.Images "gBJJgBAIDAAEg4AEEKAD/hz/EMNh8TIRNGwAjEZAEXjAojKAjMLjABhkaABAk0plUrlktl0vmExmUzmk1m03nE5nU7nk9miAoE+oVDolFo1HpFJpU5h8Sf9OqFNqUOq" & _
"NUqdPq9VrFWrlbr1QpdhAFAkFis1ntFptVrtkrpszrNvmVxqk3uVtm1kmF3sdBvF/wGBmV+j9BYGHwWJulfxdax2NyFdx2JlV6l9Nw7AAGZymdz2Cy2GxErvWcz9ivlw" & _
"yV21cuxugwktzGIzmvwtl0+53U5y0a0Wazmmyu/3dCyOMyXHx/J5nIr9q3uyqnBxFN3G46ma4vb7mD2Ng4nZze00fDkHC7t7us2rOX5tguetpHRlmz4HVqnXk1PjHO+C" & _
"MPo9MBMC+j2vC8j7wS8cFNI4kBo05UIvfCT/NsnsApU+0Fqg/T+oy/kPxC0sEQfErKQK96+w28UWRI8UGvO8sTLS9r2PWmsMJTDTask3CsIbIEQRA3shOXEEAO/GclJ9" & _
"FEKrrA8FRbKMXRIlb0JxCkjS1LMswhCcvuel0cv26cSMa8Ufx+2sQwhEUoSXOCjSbLcnxjKc7sdKUVyq28NtVI71P9P7JxtQEapjQ6fzfM8zPfNE2PhIsLL63E40slk5" & _
"y7N89LcyU9SvMb3SdUc6VJLj5VLVLfO/PS9KzNFHUa/0XyBD0dxlS9cxhMlTRSoNXypPErWDPyfNS+MwprRNO0FD8wVVZ1AI08URwVRjtJ1WCn21QkkUrXVLVPQS/XIk" & _
"FgTxT9iONZ9xVTdq+L1eKg3kkF6Upe68XtfV51/MtrVjBlwYFL1ev8y1/P6/lyzzYl02wntj0RVFmS1Qa+M5as93QxEUW9e993rfmQ2+vy65M/mL1lhl/2bj2ByVduMt" & _
"NhCJT9hdz41nN14Ld12Z9UjfI/oUAaGseiw6+uFLLhcVabJOS5RqOE0BHlZ5VnEr5fOMs3st+aa/bbRzrJGV51Y0b0DbqaWXZD90hIsPbjWu52+6Wyadpe66hhO+P/Xi" & _
"oW5rD8ZbrUZuVg6n1dsE/cXmewu1m9PVwnd35/nueXho/NaJzmjc61W76esuT77eG8pTquy9TwWH8LEzG8RDfFalx3Gcfvna9rvG/cptGLd9tuI6TZOP5Fiqi99vea+X" & _
"4VRcBq/JZZtVQ9cwSs5lsXE372+a9z7PbfB3VVqHyvMctLto8uob6eV0m/cD6MN2v+T33t6sBut42vdv2bJ8a997x2maFJfK+qArbGJPEKE+1qTflMsIdW/GCJX17KcT" & _
"6/czr/X+u1g29B7j/4BQfWkkx4zIHisjhPCmE0K4SwtXM+d4BvHRwNZOoBph9IJvPek9d40FoMJxf691jj2ywQQcHEWET4XJwkTszlVqm2GokewxtBT1DpQjRxDN0rUV" & _
"DNKdC3lb6tzNOwh6upMSSYfv4YBCl/bsn9PxiFCEo7SI6Obc9HeOrnY8x4jtHtdpN4GRbaorhsbu18Pph5CiHymI0RpSXGJ/z2oUOxYxG858AyiI+bfJtuTcG5yelBJy" & _
"T8okhqFd4a5yxL0rvulYtKCsZiWxWkc1s1cRoxxwhA31DLE0mR9l9HqX8fJgTDmFMVH0MIsRzVYnwnMi1dyzmhLt2kS2pxIiU62Wj5ptQGlSYFakLonTUJNLKaM5Wzlf" & _
"fEkuFkk5wTrhVO2eE7G6lJhxFFYUZ55zmn0WuBCD4pzhirFCKkbomsOoIYmZx5p90LoYWGPdD5g0QmJRKYxbZ6zYoVQ2jVGylSak7KSkFH6RSjpHKFuU+YMyNo5SulkC" & _
"6I0vonTCitMXPoEpVS2H5FQfEqp2R1opIgAEkJISYARTCukOhmPNI5Ex/wzGHUsicMwA1LHgQ90Y/KpoQHAD+pB/R4NzIaMAB9Xaw1gqaAOsh/A/ptIkWUfhGK1kZH8R" & _
"gH5GqvgArqRmt4AAPrTroRofBGADkqr6Rmu4D7CEaHARiwpJrEEZsXXwlVjyMWRsaRqwdkLGNBABZmytmyMnaINZqyVpLR2ftKAAAdd6h2osbaskdiq4EZtgSmyNcbVW" & _
"RJNXe3AA7REar3b0stlAAXBtoRmvJGLjEYAHUWsFcwCD/rnaop9aEICMAPdK5hT6xpeuzdOtAgKuJeGfdq6ggEbkTvAP+p9UCHXrvKkcgIA=="
.DrawGridLine = SmallDots
.AutoSize = exFixedSize
.MaxMonthX = 1
.MaxMonthY = 1
.Events.Add(Calendar1.Date).Image = 1
.EndUpdate
End With
|
|
182
|
ImageSize property on 16 (default) (specifies the size of the control' icons)
With Calendar1
.BeginUpdate
.ImageSize = 16
.FixedCellWidth = 36
.FixedCellHeight = 22
.Images "gBJJgBAIDAAEg4ACEKAD/hz/EMNh8TIRNGwAjEZAEXjAojJAjMLjABAAgjUYkUnlUrlktl0vmExmUzmk1m03nE5nU7nkrQCAntBoVDolFo1HoM/ADAplLptImdMYFOq" & _
"dSqlXq1QrVbrlGpVWsFNrNdnNjsk7pQAtNroFnt0sh8Yr9iulTuNxs1Eu8OiT/vsnsNVutXlk/oGGtVKxGLxWNtsZtN8iUYuNvy0Zvd+xNYwdwvl4p870GCqc8vOeuVt" & _
"tmp1knyOayWVy+WzN/ze1wOElenm+12WUz/Bv2/3UyyWrzeutux2GSyGP2dQ33C1ur3GD3M4zUNzHdlWjq/E3nGzVpjWv4HA7fRy/Tv2IrN8rPW6nZ3ve7mUlfu20Z8a" & _
"cvQyb+vY9jasYoDwMm+LytVBDqKG3z8O3Cb8P+mkAuY9cCQ2uL4KaxDKvkp8RNLEjqugnrwQo/UWPzFyeQw5sNLZFENrI4kOqU66pw8uzmOKvTqNqjULJvGL1JO48GtT" & _
"GsbLdEL3scxLlyiw8dQeoUVxdLTtyKmUjwGlslRPJsnK1HbAKbKCrsQo8uQk/CeP44iaR/ATnTNPLvyxPU+z9P9AUDQVBowiofJXQ6Oo+kKMpIkjztE4TKn4P6JowfgP" & _
"nwD5/nAjB8AOeAPo0eAA1IAFH07UhAIMpYAVIYFHqBUhwVjV1S1EtQAHxW65V0AZwAeuQAnwB5gAPYViEDVhwAHTQBkCjB4gOhwDmCyhH0sACAg=="
.DrawGridLine = SmallDots
.AutoSize = exFixedSize
.MaxMonthX = 1
.MaxMonthY = 1
.Events.Add(Calendar1.Date).Image = 1
.EndUpdate
End With
|
|
181
|
Is it possible to view all events the control fires
' Event event - Notifies the application once the control fires an event.
Private Sub Calendar1_Event(ByVal EventID As Long)
With Calendar1
Debug.Print( .EventParam(-2) )
End With
End Sub
|
|
180
|
Recurrence: Every Monday (using 'value' format)
With Calendar1
.BeginUpdate
.ShowMonthSelector = False
.MaxMonthX = 4
.MinMonthX = 4
.MinMonthY = 3
.MaxMonthY = 3
.AlignmentDay = CenterAlignment
.AutoSize = exFitClient
.FirstDay = Monday
.ShowNonMonthDays = False
.Background(exDateHeader) = RGB(220,220,220)
.DrawGridLine = Solid
.Date = #1/1/1997#
With .Events.Add(#9/29/1997#)
.Repetitive = "weekday(value) = 1"
.Bold = True
.ForeColor = RGB(255,0,0)
.BackgroundExt = "bottom[4,back=RGB(255,0,0)]"
End With
.EndUpdate
End With
|
|
179
|
Recurrence: The 2nd to last weekday of the month
With Calendar1
.BeginUpdate
.ShowMonthSelector = False
.MaxMonthX = 4
.MinMonthX = 4
.MinMonthY = 3
.MaxMonthY = 3
.AlignmentDay = CenterAlignment
.AutoSize = exFitClient
.FirstDay = Monday
.ShowNonMonthDays = False
.Background(exDateHeader) = RGB(220,220,220)
.DrawGridLine = Solid
.Date = #1/1/1997#
With .Events.Add(#9/29/1997#)
.Repetitive = "FREQ=MONTHLY;BYDAY=MO,TU,WE,TH,FR;BYSETPOS=-2"
.Bold = True
.ForeColor = RGB(255,0,0)
.BackgroundExt = "bottom[4,back=RGB(255,0,0)]"
End With
.EndUpdate
End With
|
|
178
|
Recurrence: The 3rd instance into the month of one of Tuesday, Wednesday or Thursday, for the next 3 months
With Calendar1
.BeginUpdate
.ShowMonthSelector = False
.MaxMonthX = 4
.MinMonthX = 4
.MinMonthY = 3
.MaxMonthY = 3
.AlignmentDay = CenterAlignment
.AutoSize = exFitClient
.FirstDay = Monday
.ShowNonMonthDays = False
.Background(exDateHeader) = RGB(220,220,220)
.DrawGridLine = Solid
.Date = #1/1/1997#
With .Events.Add(#9/4/1997#)
.Repetitive = "FREQ=MONTHLY;COUNT=3;BYDAY=TU,WE,TH;BYSETPOS=3"
.Bold = True
.ForeColor = RGB(255,0,0)
.BackgroundExt = "bottom[4,back=RGB(255,0,0)]"
End With
.EndUpdate
End With
|
|
177
|
Recurrence: The last work day of the month
With Calendar1
.BeginUpdate
.ShowMonthSelector = False
.MaxMonthX = 4
.MinMonthX = 4
.MinMonthY = 3
.MaxMonthY = 3
.AlignmentDay = CenterAlignment
.AutoSize = exFitClient
.FirstDay = Monday
.ShowNonMonthDays = False
.Background(exDateHeader) = RGB(220,220,220)
.DrawGridLine = Solid
.ShowWeeks = True
.Date = #1/1/1997#
With .Events.Add(#8/5/1997#)
.Repetitive = "FREQ=MONTHLY;BYDAY=MO,TU,WE,TH,FR;BYSETPOS=-1"
.Bold = True
.ForeColor = RGB(255,0,0)
.BackgroundExt = "bottom[4,back=RGB(255,0,0)]"
End With
.EndUpdate
End With
|
|
176
|
Recurrence: An example where the days generated makes a difference because of WKST (Sample 2)
With Calendar1
.BeginUpdate
.ShowMonthSelector = False
.MaxMonthX = 4
.MinMonthX = 4
.MinMonthY = 3
.MaxMonthY = 3
.AlignmentDay = CenterAlignment
.AutoSize = exFitClient
.FirstDay = Sunday
.ShowNonMonthDays = False
.Background(exDateHeader) = RGB(220,220,220)
.DrawGridLine = Solid
.ShowWeeks = True
.Date = #1/1/1997#
With .Events.Add(#8/5/1997#)
.Repetitive = "FREQ=WEEKLY;INTERVAL=2;COUNT=4;BYDAY=TU,SU"
.Bold = True
.ForeColor = RGB(255,0,0)
.BackgroundExt = "bottom[4,back=RGB(255,0,0)]"
End With
.EndUpdate
End With
|
|
175
|
Recurrence: An example where the days generated makes a difference because of WKST (Sample 1)
With Calendar1
.BeginUpdate
.ShowMonthSelector = False
.MaxMonthX = 4
.MinMonthX = 4
.MinMonthY = 3
.MaxMonthY = 3
.AlignmentDay = CenterAlignment
.AutoSize = exFitClient
.FirstDay = Monday
.ShowNonMonthDays = False
.Background(exDateHeader) = RGB(220,220,220)
.DrawGridLine = Solid
.ShowWeeks = True
.Date = #1/1/1997#
With .Events.Add(#8/5/1997#)
.Repetitive = "FREQ=WEEKLY;INTERVAL=2;COUNT=4;BYDAY=TU,SU"
.Bold = True
.ForeColor = RGB(255,0,0)
.BackgroundExt = "bottom[4,back=RGB(255,0,0)]"
End With
.EndUpdate
End With
|
|
174
|
Recurrence: Every four years, the first Tuesday after a Monday in November, forever (U.S. Presidential Election day)
With Calendar1
.BeginUpdate
.ShowMonthSelector = False
.MaxMonthX = 4
.MinMonthX = 4
.MinMonthY = 3
.MaxMonthY = 3
.AlignmentDay = CenterAlignment
.AutoSize = exFitClient
.FirstDay = Monday
.ShowNonMonthDays = False
.Background(exDateHeader) = RGB(220,220,220)
.DrawGridLine = Solid
.Date = #1/1/1996#
With .Events.Add(#11/5/1996#)
.Repetitive = "FREQ=YEARLY;INTERVAL=4;BYMONTH=11;BYDAY=TU;BYMONTHDAY=2,3,4,5,6,7,8"
.Bold = True
.ForeColor = RGB(255,0,0)
.BackgroundExt = "bottom[4,back=RGB(255,0,0)]"
End With
.EndUpdate
End With
|
|
173
|
Recurrence: The first Saturday that follows the first Sunday of the month, forever
With Calendar1
.BeginUpdate
.ShowMonthSelector = False
.MaxMonthX = 4
.MinMonthX = 4
.MinMonthY = 3
.MaxMonthY = 3
.AlignmentDay = CenterAlignment
.AutoSize = exFitClient
.FirstDay = Monday
.ShowNonMonthDays = False
.Background(exDateHeader) = RGB(220,220,220)
.DrawGridLine = Solid
.Date = #1/1/1997#
With .Events.Add(#9/13/1997#)
.Bold = True
.ForeColor = RGB(255,0,0)
.Repetitive = "FREQ=MONTHLY;BYDAY=SA;BYMONTHDAY=7,8,9,10,11,12,13"
.BackgroundExt = "bottom[4,back=RGB(255,0,0)]"
End With
.EndUpdate
End With
|
|
172
|
Recurrence: Every Friday the 13th, forever
With Calendar1
.BeginUpdate
.ShowMonthSelector = False
.MaxMonthX = 4
.MinMonthX = 4
.MinMonthY = 3
.MaxMonthY = 3
.AlignmentDay = CenterAlignment
.AutoSize = exFitClient
.FirstDay = Monday
.ShowNonMonthDays = False
.Background(exDateHeader) = RGB(220,220,220)
.DrawGridLine = Solid
.Date = #1/1/1997#
With .Events.Add(#9/2/1997#)
.Repetitive = "FREQ=MONTHLY;BYDAY=FR;BYMONTHDAY=13"
.Bold = True
.ForeColor = RGB(255,0,0)
.BackgroundExt = "bottom[4,back=RGB(255,0,0)]"
End With
.EndUpdate
End With
|
|
171
|
Recurrence: Every Thursday, but only during June, July, and August, forever
With Calendar1
.BeginUpdate
.ShowMonthSelector = False
.MaxMonthX = 4
.MinMonthX = 4
.MinMonthY = 3
.MaxMonthY = 3
.AlignmentDay = CenterAlignment
.AutoSize = exFitClient
.FirstDay = Monday
.ShowNonMonthDays = False
.Background(exDateHeader) = RGB(220,220,220)
.DrawGridLine = Solid
.Date = #1/1/1997#
With .Events.Add(#6/5/1997#)
.Repetitive = "FREQ=YEARLY;BYDAY=TH;BYMONTH=6,7,8"
.Bold = True
.ForeColor = RGB(255,0,0)
.BackgroundExt = "bottom[4,back=RGB(255,0,0)]"
End With
.EndUpdate
End With
|
|
170
|
Recurrence: Every Thursday in March, forever
With Calendar1
.BeginUpdate
.ShowMonthSelector = False
.MaxMonthX = 4
.MinMonthX = 4
.MinMonthY = 3
.MaxMonthY = 3
.AlignmentDay = CenterAlignment
.AutoSize = exFitClient
.FirstDay = Monday
.ShowNonMonthDays = False
.Background(exDateHeader) = RGB(220,220,220)
.DrawGridLine = Solid
.Date = #1/1/1997#
With .Events.Add(#3/13/1997#)
.Repetitive = "FREQ=YEARLY;BYMONTH=3;BYDAY=TH"
.Bold = True
.ForeColor = RGB(255,0,0)
.BackgroundExt = "bottom[4,back=RGB(255,0,0)]"
End With
.EndUpdate
End With
|
|
169
|
Recurrence: Monday of week number 20 (where the default start of the week is Monday), forever
With Calendar1
.BeginUpdate
.ShowMonthSelector = False
.MaxMonthX = 4
.MinMonthX = 4
.MinMonthY = 3
.MaxMonthY = 3
.AlignmentDay = CenterAlignment
.AutoSize = exFitClient
.FirstDay = Monday
.ShowNonMonthDays = False
.Background(exDateHeader) = RGB(220,220,220)
.DrawGridLine = Solid
.ShowWeeks = True
.Date = #1/1/1997#
With .Events.Add(#5/12/1997#)
.Repetitive = "FREQ=YEARLY;BYWEEKNO=20;BYDAY=MO"
.Bold = True
.ForeColor = RGB(255,0,0)
.BackgroundExt = "bottom[4,back=RGB(255,0,0)]"
End With
.EndUpdate
End With
|
|
168
|
Recurrence: Every 20th Monday of the year, forever
With Calendar1
.BeginUpdate
.ShowMonthSelector = False
.MaxMonthX = 4
.MinMonthX = 4
.MinMonthY = 3
.MaxMonthY = 3
.AlignmentDay = CenterAlignment
.AutoSize = exFitClient
.FirstDay = Monday
.ShowNonMonthDays = False
.Background(exDateHeader) = RGB(220,220,220)
.DrawGridLine = Solid
.Date = #1/1/1997#
With .Events.Add(#1/1/1997#)
.Repetitive = "FREQ=YEARLY;BYDAY=20MO"
.Bold = True
.ForeColor = RGB(255,0,0)
.BackgroundExt = "bottom[4,back=RGB(255,0,0)]"
End With
.EndUpdate
End With
|
|
167
|
Recurrence: Every 3rd year on the 1st, 100th and 200th day for 10 occurrences
With Calendar1
.BeginUpdate
.ShowMonthSelector = False
.MaxMonthX = 4
.MinMonthX = 4
.MinMonthY = 3
.MaxMonthY = 3
.AlignmentDay = CenterAlignment
.AutoSize = exFitClient
.FirstDay = Monday
.ShowNonMonthDays = False
.Background(exDateHeader) = RGB(220,220,220)
.DrawGridLine = Solid
.Date = #1/1/1997#
With .Events.Add(#1/1/1997#)
.Repetitive = "FREQ=YEARLY;INTERVAL=3;COUNT=10;BYYEARDAY=1,100,200"
.Bold = True
.ForeColor = RGB(255,0,0)
.BackgroundExt = "bottom[4,back=RGB(255,0,0)]"
End With
.EndUpdate
End With
|
|
166
|
Recurrence: Every other year on January, February, and March for 10 occurrences
With Calendar1
.BeginUpdate
.ShowMonthSelector = False
.MaxMonthX = 4
.MinMonthX = 4
.MinMonthY = 3
.MaxMonthY = 3
.AlignmentDay = CenterAlignment
.AutoSize = exFitClient
.FirstDay = Monday
.ShowNonMonthDays = False
.Background(exDateHeader) = RGB(220,220,220)
.DrawGridLine = Solid
.Date = #1/1/1997#
With .Events.Add(#3/10/1997#)
.Repetitive = "FREQ=YEARLY;INTERVAL=2;COUNT=10;BYMONTH=1,2,3"
.Bold = True
.ForeColor = RGB(255,0,0)
.BackgroundExt = "bottom[4,back=RGB(255,0,0)]"
End With
.EndUpdate
End With
|
|
165
|
Recurrence: Yearly in June and July for 10 occurrences
With Calendar1
.BeginUpdate
.ShowMonthSelector = False
.MaxMonthX = 4
.MinMonthX = 4
.MinMonthY = 3
.MaxMonthY = 3
.AlignmentDay = CenterAlignment
.AutoSize = exFitClient
.FirstDay = Monday
.ShowNonMonthDays = False
.Background(exDateHeader) = RGB(220,220,220)
.DrawGridLine = Solid
.Date = #1/1/1997#
With .Events.Add(#6/10/1997#)
.Repetitive = "FREQ=YEARLY;COUNT=10;BYMONTH=6,7"
.Bold = True
.ForeColor = RGB(255,0,0)
.BackgroundExt = "bottom[4,back=RGB(255,0,0)]"
End With
.EndUpdate
End With
|
|
164
|
Recurrence: Every Tuesday, every other month
With Calendar1
.BeginUpdate
.ShowMonthSelector = False
.MaxMonthX = 4
.MinMonthX = 4
.MinMonthY = 3
.MaxMonthY = 3
.AlignmentDay = CenterAlignment
.AutoSize = exFitClient
.FirstDay = Monday
.ShowNonMonthDays = False
.Background(exDateHeader) = RGB(220,220,220)
.DrawGridLine = Solid
.Date = #1/1/1997#
With .Events.Add(#9/2/1997#)
.Repetitive = "FREQ=MONTHLY;INTERVAL=2;BYDAY=TU"
.Bold = True
.ForeColor = RGB(255,0,0)
.BackgroundExt = "bottom[4,back=RGB(255,0,0)]"
End With
.EndUpdate
End With
|
|
163
|
Recurrence: Every 18 months on the 10th thru 15th of the month for 10 occurrences
With Calendar1
.BeginUpdate
.ShowMonthSelector = False
.MaxMonthX = 4
.MinMonthX = 4
.MinMonthY = 3
.MaxMonthY = 3
.AlignmentDay = CenterAlignment
.AutoSize = exFitClient
.FirstDay = Monday
.ShowNonMonthDays = False
.Background(exDateHeader) = RGB(220,220,220)
.DrawGridLine = Solid
.Date = #1/1/1997#
With .Events.Add(#9/10/1997#)
.Repetitive = "FREQ=MONTHLY;INTERVAL=18;COUNT=10;BYMONTHDAY=10,11,12,13,14,15"
.Bold = True
.ForeColor = RGB(255,0,0)
.BackgroundExt = "bottom[4,back=RGB(255,0,0)]"
End With
.EndUpdate
End With
|
|
162
|
Recurrence: Monthly on the first and last day of the month for 10 occurrences
With Calendar1
.BeginUpdate
.ShowMonthSelector = False
.MaxMonthX = 4
.MinMonthX = 4
.MinMonthY = 3
.MaxMonthY = 3
.AlignmentDay = CenterAlignment
.AutoSize = exFitClient
.FirstDay = Monday
.ShowNonMonthDays = False
.Background(exDateHeader) = RGB(220,220,220)
.DrawGridLine = Solid
.Date = #1/1/1997#
With .Events.Add(#9/3/1997#)
.Repetitive = "FREQ=MONTHLY;COUNT=10;BYMONTHDAY=1,-1"
.Bold = True
.ForeColor = RGB(255,0,0)
.BackgroundExt = "bottom[4,back=RGB(255,0,0)]"
End With
.EndUpdate
End With
|
|
161
|
Recurrence: Monthly on the 2nd and 15th of the month for 10 occurrences
With Calendar1
.BeginUpdate
.ShowMonthSelector = False
.MaxMonthX = 4
.MinMonthX = 4
.MinMonthY = 3
.MaxMonthY = 3
.AlignmentDay = CenterAlignment
.AutoSize = exFitClient
.FirstDay = Monday
.ShowNonMonthDays = False
.Background(exDateHeader) = RGB(220,220,220)
.DrawGridLine = Solid
.Date = #1/1/1997#
With .Events.Add(#9/2/1997#)
.Repetitive = "FREQ=MONTHLY;COUNT=10;BYMONTHDAY=2,15"
.Bold = True
.ForeColor = RGB(255,0,0)
.BackgroundExt = "bottom[4,back=RGB(255,0,0)]"
End With
.EndUpdate
End With
|
|
160
|
Recurrence: Monthly on the third to the last day of the month, forever
With Calendar1
.BeginUpdate
.ShowMonthSelector = False
.MaxMonthX = 4
.MinMonthX = 4
.MinMonthY = 3
.MaxMonthY = 3
.AlignmentDay = CenterAlignment
.AutoSize = exFitClient
.FirstDay = Monday
.ShowNonMonthDays = False
.Background(exDateHeader) = RGB(220,220,220)
.DrawGridLine = Solid
.Date = #1/1/1997#
With .Events.Add(#9/28/1997#)
.Repetitive = "FREQ=MONTHLY;BYMONTHDAY=-3"
.Bold = True
.ForeColor = RGB(255,0,0)
.BackgroundExt = "bottom[4,back=RGB(255,0,0)]"
End With
.EndUpdate
End With
|
|
159
|
Recurrence: Monthly on the second to last Monday of the month for 6 months
With Calendar1
.BeginUpdate
.ShowMonthSelector = False
.MaxMonthX = 4
.MinMonthX = 4
.MinMonthY = 3
.MaxMonthY = 3
.AlignmentDay = CenterAlignment
.AutoSize = exFitClient
.FirstDay = Monday
.ShowNonMonthDays = False
.Background(exDateHeader) = RGB(220,220,220)
.DrawGridLine = Solid
.Date = #1/1/1997#
With .Events.Add(#9/22/1997#)
.Repetitive = "FREQ=MONTHLY;COUNT=6;BYDAY=-2MO"
.Bold = True
.ForeColor = RGB(255,0,0)
.BackgroundExt = "bottom[4,back=RGB(255,0,0)]"
End With
.EndUpdate
End With
|
|
158
|
Recurrence: Every other month on the 1st and last Sunday of the month for 10 occurrences
With Calendar1
.BeginUpdate
.ShowMonthSelector = False
.MaxMonthX = 4
.MinMonthX = 4
.MinMonthY = 3
.MaxMonthY = 3
.AlignmentDay = CenterAlignment
.AutoSize = exFitClient
.FirstDay = Monday
.ShowNonMonthDays = False
.Background(exDateHeader) = RGB(220,220,220)
.DrawGridLine = Solid
.Date = #1/1/1997#
With .Events.Add(#9/7/1997#)
.Repetitive = "FREQ=MONTHLY;INTERVAL=2;COUNT=10;BYDAY=1SU,-1SU"
.Bold = True
.ForeColor = RGB(255,0,0)
.BackgroundExt = "bottom[4,back=RGB(255,0,0)]"
End With
.EndUpdate
End With
|
|
157
|
Recurrence: Monthly on the 1st Friday until December 24, 1997
With Calendar1
.BeginUpdate
.ShowMonthSelector = False
.MaxMonthX = 4
.MinMonthX = 4
.MinMonthY = 3
.MaxMonthY = 3
.AlignmentDay = CenterAlignment
.AutoSize = exFitClient
.FirstDay = Monday
.ShowNonMonthDays = False
.Background(exDateHeader) = RGB(220,220,220)
.DrawGridLine = Solid
.Date = #1/1/1997#
With .Events.Add(#9/5/1997#)
.Repetitive = "FREQ=MONTHLY;UNTIL=19971224T000000Z;BYDAY=1FR"
.Bold = True
.ForeColor = RGB(255,0,0)
.BackgroundExt = "bottom[4,back=RGB(255,0,0)]"
End With
.EndUpdate
End With
|
|
156
|
Recurrence: Monthly on the 1st Friday for ten occurrences
With Calendar1
.BeginUpdate
.ShowMonthSelector = False
.MaxMonthX = 4
.MinMonthX = 4
.MinMonthY = 3
.MaxMonthY = 3
.AlignmentDay = CenterAlignment
.AutoSize = exFitClient
.FirstDay = Monday
.ShowNonMonthDays = False
.Background(exDateHeader) = RGB(220,220,220)
.DrawGridLine = Solid
.Date = #1/1/1997#
With .Events.Add(#9/5/1997#)
.Repetitive = "FREQ=MONTHLY;COUNT=10;BYDAY=1FR"
.Bold = True
.ForeColor = RGB(255,0,0)
.BackgroundExt = "bottom[4,back=RGB(255,0,0)]"
End With
.EndUpdate
End With
|
|
155
|
Recurrence: Every other week on Tuesday and Thursday, for 8 occurrences
With Calendar1
.BeginUpdate
.ShowMonthSelector = False
.MaxMonthX = 4
.MinMonthX = 4
.MinMonthY = 3
.MaxMonthY = 3
.AlignmentDay = CenterAlignment
.AutoSize = exFitClient
.FirstDay = Sunday
.ShowNonMonthDays = False
.Background(exDateHeader) = RGB(220,220,220)
.DrawGridLine = Solid
.Date = #1/1/1997#
With .Events.Add(#9/2/1997#)
.Repetitive = "FREQ=WEEKLY;INTERVAL=2;COUNT=8;WKST=SU;BYDAY=TU,TH"
.Bold = True
.ForeColor = RGB(255,0,0)
.BackgroundExt = "bottom[4,back=RGB(255,0,0)]"
End With
.EndUpdate
End With
|
|
154
|
Recurrence: Every other week on Monday, Wednesday and Friday until December 24, 1997, but starting on Tuesday, September 2, 1997
With Calendar1
.BeginUpdate
.ShowMonthSelector = False
.MaxMonthX = 4
.MinMonthX = 4
.MinMonthY = 3
.MaxMonthY = 3
.AlignmentDay = CenterAlignment
.AutoSize = exFitClient
.FirstDay = Sunday
.ShowNonMonthDays = False
.Background(exDateHeader) = RGB(220,220,220)
.DrawGridLine = Solid
.Date = #1/1/1997#
With .Events.Add(#9/2/1997#)
.Repetitive = "FREQ=WEEKLY;INTERVAL=2;UNTIL=19971224T000000Z;WKST=SU;BYDAY=MO,WE,FR"
.Bold = True
.ForeColor = RGB(255,0,0)
.BackgroundExt = "bottom[4,back=RGB(255,0,0)]"
End With
.EndUpdate
End With
|
|
153
|
Recurrence: Weekly on Tuesday and Thursday for 5 weeks
With Calendar1
.BeginUpdate
.ShowMonthSelector = False
.MaxMonthX = 4
.MinMonthX = 4
.MinMonthY = 3
.MaxMonthY = 3
.AlignmentDay = CenterAlignment
.AutoSize = exFitClient
.FirstDay = Sunday
.ShowNonMonthDays = False
.Background(exDateHeader) = RGB(220,220,220)
.DrawGridLine = Solid
.Date = #1/1/1997#
With .Events.Add(#9/2/1997#)
.Repetitive = "FREQ=WEEKLY;UNTIL=19971007T000000Z;WKST=SU;BYDAY=TU,TH"
.Bold = True
.ForeColor = RGB(255,0,0)
.BackgroundExt = "bottom[4,back=RGB(255,0,0)]"
End With
.EndUpdate
End With
|
|
152
|
Recurrence: Weekly on Tuesday and Thursday for 5 weeks
With Calendar1
.BeginUpdate
.ShowMonthSelector = False
.MaxMonthX = 4
.MinMonthX = 4
.MinMonthY = 3
.MaxMonthY = 3
.AlignmentDay = CenterAlignment
.AutoSize = exFitClient
.FirstDay = Monday
.ShowNonMonthDays = False
.Background(exDateHeader) = RGB(220,220,220)
.DrawGridLine = Solid
.Date = #1/1/1997#
With .Events.Add(#9/2/1997#)
.Repetitive = "FREQ=WEEKLY;COUNT=10;WKST=SU;BYDAY=TU,TH"
.Bold = True
.ForeColor = RGB(255,0,0)
.BackgroundExt = "bottom[4,back=RGB(255,0,0)]"
End With
.EndUpdate
End With
|
|
151
|
Recurrence: Every other day - forever
With Calendar1
.BeginUpdate
.ShowMonthSelector = False
.MaxMonthX = 4
.MinMonthX = 4
.MinMonthY = 3
.MaxMonthY = 3
.AlignmentDay = CenterAlignment
.AutoSize = exFitClient
.FirstDay = Monday
.ShowNonMonthDays = False
.Background(exDateHeader) = RGB(220,220,220)
.DrawGridLine = Solid
.Date = #1/1/1997#
With .Events.Add(#9/2/1997#)
.Repetitive = "FREQ=DAILY;INTERVAL=2"
.Bold = True
.ForeColor = RGB(255,0,0)
.BackgroundExt = "bottom[4,back=RGB(255,0,0)]"
End With
.EndUpdate
End With
|
|
150
|
Recurrence: Daily until December 24, 1997
With Calendar1
.BeginUpdate
.ShowMonthSelector = False
.MaxMonthX = 4
.MinMonthX = 4
.MinMonthY = 3
.MaxMonthY = 3
.AlignmentDay = CenterAlignment
.AutoSize = exFitClient
.FirstDay = Monday
.ShowNonMonthDays = False
.Background(exDateHeader) = RGB(220,220,220)
.DrawGridLine = Solid
.Date = #1/1/1997#
With .Events.Add(#9/2/1997#)
.Repetitive = "FREQ=DAILY;UNTIL=19971224T000000Z"
.Bold = True
.ForeColor = RGB(255,0,0)
.BackgroundExt = "bottom[4,back=RGB(255,0,0)]"
End With
.EndUpdate
End With
|
|
149
|
Recurrence: Daily for 10 occurrences
With Calendar1
.BeginUpdate
.ShowMonthSelector = False
.MaxMonthX = 4
.MinMonthX = 4
.MinMonthY = 3
.MaxMonthY = 3
.AlignmentDay = CenterAlignment
.AutoSize = exFitClient
.FirstDay = Monday
.ShowNonMonthDays = False
.Background(exDateHeader) = RGB(220,220,220)
.DrawGridLine = Solid
.Date = #1/1/1997#
With .Events.Add(#9/2/1997#)
.Repetitive = "FREQ=DAILY;COUNT=10"
.Bold = True
.ForeColor = RGB(255,0,0)
.BackgroundExt = "bottom[4,back=RGB(255,0,0)]"
End With
.EndUpdate
End With
|
|
148
|
How can I show a single month
With Calendar1
.BeginUpdate
.MaxMonthX = 1
.MaxMonthY = 1
.ShowTodayButton = False
.ShowMonthSelector = False
.ShowYearScroll = False
.AlignmentDay = CenterAlignment
.ShowWeeks = True
.EndUpdate
End With
|
|
147
|
How can I display the week-number in ISO8601 format
With Calendar1
.BeginUpdate
.FirstDay = Monday
.DisplayWeekNumberAs = exISO8601WeekNumber
.Date = #1/1/2001#
.MinMonthX = 3
.MaxMonthX = .MinMonthX
.MinMonthY = 4
.MaxMonthY = .MinMonthY
.ShowWeeks = True
.EndUpdate
End With
|
|
146
|
Can I include the month's number in the date header
With Calendar1
.BeginUpdate
.Appearance = None2
.Background(exDateHeader) = .BackColor
.FirstDay = Monday
.DrawGridLine = Solid
.WeekDays = "Su Mo Tu We Th Fr Sa"
.MarkToday = True
.AutoSize = exFixedSize
.AlignmentDay = CenterAlignment
.FixedCellHeight = 32
.FixedCellWidth = 32
.DateHeaderFormat = "1,(""""[b=0],(""""[b=0]/24;2[b=0][bg=0x01000000]/""""[b=0]):24,""""[b=0]):32,(""""[b=0],(""""[b=0]/24;3[b=0][bg=0x01000000]/"""" & _
""[b=0]):24,""""[b=0]):32"
.DateHeaderField(exHeaderDate) = "`<c><%month%> (` + (dateF(value) left 2) + `) <r><off -6><font ;6><%year%>`"
With .VisualAppearance
.Add 1,"gBFLBCJwBAEHhEJAAEhABFgDg6AADACAxSDEMQBQKAAzQFAYbhgHCGAAGQaBUgmFgAQhFcZQSKUOQTDKMIziYBYfgkMIgSbJUgDGAkRRdDSOYIkWA5AiKEYoThCIxzT" & _
"J8aw3CKbYRAKCXfoUAJFP7Fc6ABJMBx3EyhZ89NDYEwTIKBahoehqIheEQyDSJNb2DCIahhMSEbKtCooDhGFpUWzLdxTJJVawHJoABjkS45PjEAJ+SBPUZVRRlFyfO7B" & _
"KSjMKKXgkG4zABWVa1bC1FzxQ6mKykKQLQADDIDVZAeL3JTNCS5IyLLDtO77EqmZ5la7cUgRDj4AY7Ua+MzubBZaovOqDYzAey7TDWLRXFDNIzzTgQAyHHrETZHGqwJx" & _
"MAEapYGqYpVi2HwzDuQ5oHKIQgggSSUGMOgdE4RhYDwJBVAwIQTH2UYhjQJBRAmZxuCEHZ3icJp5EgKxgAIVgCCQSQSEIBQkCAYhCAIJYKmKNIuFcTBIESPYEk6GBUm+" & _
"BZOmOPgZgWYRTiYEwvEwaIEAAK4KnKOJrgmTpDjCbYJmKSI2CoOxihOLglCuAACioNg8COA4gmcOZOiidg+g+Dh4moOA8CMYokNmCoyiycQ8E8A4iE6D4OjOMgng8ZJj" & _
"iITA8CSEouEcKwKkkLJyhQIoIkYU9LjORhcCsAAIACLQ8iaSJ6FKC5jJoaobA8KYoACCRKnmMJzhuDpZnSboMCKGJ4nMPIPDmYAACwKIDk6CoLCeU40m6I5oliMoKDya" & _
"ICokLIpgoThviOKJoGYf4KmUKhMjMLJLCAAojCyaYoiYGoGmqM46CkOwPEoKonAACxKlSdItmiWBeBeDgrioNo3D0KxSlAAAtgsUpYnUPRPEoco8hCa+T40SxbBRj5tE" & _
"sHJ1i6JhbGYS4ug8awelQLZAAKZI5C4DxrhYQ9ehmUppWiA48nAPRuFKYpiAAC47laZQ9iuKZSgOPotkuFI7C6C4gACPJAm8eQOhOQZoikDp3kCS5AACPoEk8fBGnqQg" & _
"pDOSppD2TxjlyPZD6CfwekQTx5lKP5ImseZTCAL5MAMAAAkoTADmMLpIjISp+HSS4PgyMAADBzAHDSIoPCOUpWjObIKE8NJOHKIwPEaTprBsHpdjWLB9AieQ+DQYwQAA" & _
"MR1EOZxWi+bx7HcWQ8msfRYnnDZQACRwxgwc5rGaMZPE0ZxqjWNZtgyRwAAyTZEnuXJzEyAx2kQcxNkye5cEy3cYAcANrGAIH4OAhx3gNGGPAfgIR8jBA4McBMARVhnH" & _
"4HQOYmxuCpF2MsecEQVBvGQCcIQug6itGQBoARAQ="
End With
.EndUpdate
End With
|
|
145
|
How can I display the previously/next month in the date header
With Calendar1
.BeginUpdate
.Appearance = None2
.Background(exDateHeader) = .BackColor
.FirstDay = Monday
.MaxMonthX = 1
.MaxMonthY = 1
.DrawGridLine = Solid
.WeekDays = "Su Mo Tu We Th Fr Sa"
.MarkToday = True
.AutoSize = exFixedSize
.AlignmentDay = CenterAlignment
.FixedCellHeight = 32
.FixedCellWidth = 32
.DateHeaderFormat = "2[b=0][bg=RGB(240,240,240)]:32,1,3[b=0][bg=RGB(240,240,240)]:32"
.DateHeaderField(exHeaderPrevMonth) = "`<c>` + ( ( ((0:=((month(value) - 1) - 1) ) < 0 ? 11 : =:0 ) array `January February March April May June July August September" & _
" October November December` split ` ` ) left 3 ) "
.DateHeaderField(exHeaderNextMonth) = "`<c>` + ( ( ((0:=((month(value) - 1) + 1) ) = 12 ? 0 : =:0 ) array `January February March April May June July August September" & _
" October November December` split ` ` ) left 3 ) "
.EndUpdate
End With
|
|
144
|
How can I display the year to a different position
With Calendar1
.BeginUpdate
.Appearance = None2
.Background(exDateHeader) = .BackColor
.FirstDay = Monday
.MaxMonthX = 1
.MaxMonthY = 1
.DrawGridLine = Solid
.WeekDays = "Su Mo Tu We Th Fr Sa"
.MarkToday = True
.AutoSize = exFixedSize
.AlignmentDay = CenterAlignment
.FixedCellHeight = 32
.FixedCellWidth = 32
.DateHeaderFormat = "6/(1,2[bg=RGB(196,196,196)]:32,3[bg=RGB(196,196,196)]:32)"
.HTMLPicture("up") = "gCJKBOI4NBQaBQAhQNJJIIhShQACERCAIA0RD7zf5hiJZJJEIJUPDaMZkUAQGAOP4DRShOgvHIGQA0U5CbKzOIZYRIICzCaUX4PS4hRgEGg/QaKJLhGSESIIZoMfAMM" & _
"IkKQzJxDDBJaCMaoQSABVhAXgQRBLRFdNhIB4QY4PfyUJB7AYAFo+DIWOb7LDdiIAJJFJxEVxCMCCgIA="
.HTMLPicture("down") = "gCJKBOI4NBQaBQAhQNJJIIhShQACERCAIA0RD7zf5hiIEM5BJpBhSxR4LfhhAsRKZJIhBKg4J7tRjJBIAEAMAjzWIJba0E5rWQcWaBAoFR7oK4HewRZCMPiMUDLXRoS" & _
"4PfjCQJrEhdaJ5ET4YIvTgOJ5kFSTKpkFaTKLEFqTGxyFgTIyuMgCeJaPwDSIKEhlCT5ZoWFT4iIAJJFJxEVxCMCCgIA="
.DateHeaderField(exHeaderPrevMonth) = "<c><img>up</img>"
.DateHeaderField(exHeaderNextMonth) = "<c><img>down</img>"
.DateHeaderField(exHeaderDate) = "<c><%month%>"
.DateHeaderField(HeaderFieldEnum.exHeaderPrevYear Or HeaderFieldEnum.exHeaderPrevMonth) = "<r><b><%year%>"
.EndUpdate
End With
|
|
143
|
Can I display some extra text/caption on the month's header
With Calendar1
.BeginUpdate
.Appearance = None2
.Background(exDateHeader) = .BackColor
.FirstDay = Monday
.MaxMonthX = 1
.MaxMonthY = 1
.DrawGridLine = Solid
.WeekDays = "Su Mo Tu We Th Fr Sa"
.MarkToday = True
.AutoSize = exFixedSize
.AlignmentDay = CenterAlignment
.FixedCellHeight = 32
.FixedCellWidth = 32
.DateHeaderFormat = "(""<sha ;;0>calendar""[a=17]/1),2:32,3:32"
.HTMLPicture("up") = "gCJKBOI4NBQaBQAhQNJJIIhShQACERCAIA0RD7zf5hiJZJJEIJUPDaMZkUAQGAOP4DRShOgvHIGQA0U5CbKzOIZYRIICzCaUX4PS4hRgEGg/QaKJLhGSESIIZoMfAMM" & _
"IkKQzJxDDBJaCMaoQSABVhAXgQRBLRFdNhIB4QY4PfyUJB7AYAFo+DIWOb7LDdiIAJJFJxEVxCMCCgIA="
.HTMLPicture("down") = "gCJKBOI4NBQaBQAhQNJJIIhShQACERCAIA0RD7zf5hiIEM5BJpBhSxR4LfhhAsRKZJIhBKg4J7tRjJBIAEAMAjzWIJba0E5rWQcWaBAoFR7oK4HewRZCMPiMUDLXRoS" & _
"4PfjCQJrEhdaJ5ET4YIvTgOJ5kFSTKpkFaTKLEFqTGxyFgTIyuMgCeJaPwDSIKEhlCT5ZoWFT4iIAJJFJxEVxCMCCgIA="
.DateHeaderField(exHeaderPrevMonth) = "<c><img>up</img>"
.DateHeaderField(exHeaderNextMonth) = "<c><img>down</img>"
.DateHeaderField(exHeaderDate) = "<c><b><%month%>"
.EndUpdate
End With
|
|
142
|
How can I display no year on th month's header
With Calendar1
.BeginUpdate
.Appearance = None2
.Background(exDateHeader) = .BackColor
.FirstDay = Monday
.MaxMonthX = 2
.MaxMonthY = 2
.DrawGridLine = Solid
.WeekDays = "Su Mo Tu We Th Fr Sa"
.MarkToday = True
.AutoSize = exFixedSize
.AlignmentDay = CenterAlignment
.FixedCellHeight = 32
.FixedCellWidth = 32
.DateHeaderFormat = "1,2:32,3:32"
.HTMLPicture("up") = "gCJKBOI4NBQaBQAhQNJJIIhShQACERCAIA0RD7zf5hiJZJJEIJUPDaMZkUAQGAOP4DRShOgvHIGQA0U5CbKzOIZYRIICzCaUX4PS4hRgEGg/QaKJLhGSESIIZoMfAMM" & _
"IkKQzJxDDBJaCMaoQSABVhAXgQRBLRFdNhIB4QY4PfyUJB7AYAFo+DIWOb7LDdiIAJJFJxEVxCMCCgIA="
.HTMLPicture("down") = "gCJKBOI4NBQaBQAhQNJJIIhShQACERCAIA0RD7zf5hiIEM5BJpBhSxR4LfhhAsRKZJIhBKg4J7tRjJBIAEAMAjzWIJba0E5rWQcWaBAoFR7oK4HewRZCMPiMUDLXRoS" & _
"4PfjCQJrEhdaJ5ET4YIvTgOJ5kFSTKpkFaTKLEFqTGxyFgTIyuMgCeJaPwDSIKEhlCT5ZoWFT4iIAJJFJxEVxCMCCgIA="
.DateHeaderField(exHeaderPrevMonth) = "<c><img>up</img>"
.DateHeaderField(exHeaderNextMonth) = "<c><img>down</img>"
.DateHeaderField(exHeaderDate) = "<c><b><%month%>"
.EndUpdate
End With
|
|
141
|
How can I arrange the month's header ( first and last month only, prev month, next, prev year, picture, ebn, expression)
With Calendar1
.BeginUpdate
.Appearance = None2
.Background(exDateHeader) = .BackColor
.FirstDay = Monday
.MaxMonthX = 2
.MaxMonthY = 2
.DrawGridLine = Solid
.WeekDays = "Su Mo Tu We Th Fr Sa"
.MarkToday = True
.AutoSize = exFixedSize
.AlignmentDay = CenterAlignment
.FixedCellHeight = 32
.FixedCellWidth = 32
.DateHeaderFormat = " (( xmax * ymax ) = 1 ) ? `2[b=0][bg=0x01000000]:32,1,3[b=0][bg=0x01000000]:32` : ( ( x = 0 and y = 0 ) ? `2[b=0][bg=0x01000000" & _
"]:32,1`: ( ( x = xmax - 1 and y = ymax - 1 ) ? `1,3[b=0][bg=0x01000000]:32`: `1` ) )"
.DateHeaderField(exHeaderDate) = " ( ( ( month(value) = month(date(``) ) and ( year(value) = year(date(``) ) ) ) ) ? `<b><fgcolor=0000FF>` : `` ) + `<c><%month%>" & _
"</b> <off -6><font ;7><%year%>`"
.HTMLPicture("up") = "gCJKBOI4NBQaBQAhQNJJIIhShQACERCAIA0RD7zf5hiJZJJEIJUPDaMZkUAQGAOP4DRShOgvHIGQA0U5CbKzOIZYRIICzCaUX4PS4hRgEGg/QaKJLhGSESIIZoMfAMM" & _
"IkKQzJxDDBJaCMaoQSABVhAXgQRBLRFdNhIB4QY4PfyUJB7AYAFo+DIWOb7LDdiIAJJFJxEVxCMCCgIA="
.HTMLPicture("down") = "gCJKBOI4NBQaBQAhQNJJIIhShQACERCAIA0RD7zf5hiIEM5BJpBhSxR4LfhhAsRKZJIhBKg4J7tRjJBIAEAMAjzWIJba0E5rWQcWaBAoFR7oK4HewRZCMPiMUDLXRoS" & _
"4PfjCQJrEhdaJ5ET4YIvTgOJ5kFSTKpkFaTKLEFqTGxyFgTIyuMgCeJaPwDSIKEhlCT5ZoWFT4iIAJJFJxEVxCMCCgIA="
.HTMLPicture("left") = "gCJKBOI4NBQaBQAhQNJJIIhShQACERCAIA0RD7zf5hiJUJJEIJUPDaMZkEANWACeJvMgBIwSGgXAaxGIQI6RMYAJBzFQQHYBeIzKQNYCpTIYAbwNQmMgAILNfAMEBKG" & _
"YuAaIaxMGYDFD2ARVASRNBDNCeSAIDRCW7MAgDDDZDIAKbADgRVrfUCNiIAJJFJxEVxCMCCgI"
.HTMLPicture("right") = "gCJKBOI4NBQaBQAhQNJJIIhShQACERCAIA0RD7zf5hiIBOZSI5CACuZwcdMRAhnIJNIMKWKPBb8MIFiIJOBILJzhQOYc7YYBY5vVBkiJEJJEIJUHBPMbAARYUI0KKAD" & _
"JKEaDEpAVgAYjHYI8GSACgQb4AcRiGCPJgwNQIEzANIICaUUwpUDIBYjKIzBAsAZiWQ1QYABLZTKBAIATL2CUxXJdV8RABJIpOIiuIRgQUBA="
.DateHeaderField(exHeaderPrevMonth) = "<c><img>up</img>"
.DateHeaderField(exHeaderNextMonth) = "<c><img>down</img>"
.DateHeaderField(exHeaderPrevYear) = "<c><img>left</img>"
.DateHeaderField(exHeaderNextYear) = "<c><img>right</img>"
With .VisualAppearance
.Add 1,"gBFLBCJwBAEHhEJAAEhABFgDg6AADACAxSDEMQBQKAAzQFAYbhgHCGAAGQaBUgmFgAQhFcZQSKUOQTDKMIziYBYfgkMIgSbJUgDGAkRRdDSOYIkWA5AiKEYoThCIxzT" & _
"J8aw3CKbYRAKCXfoUAJFP7Fc6ABJMBx3EyhZ89NDYEwTIKBahoehqIheEQyDSJNb2DCIahhMSEbKtCooDhGFpUWzLdxTJJVawHJoABjkS45PjEAJ+SBPUZVRRlFyfO7B" & _
"KSjMKKXgkG4zABWVa1bC1FzxQ6mKykKQLQADDIDVZAeL3JTNCS5IyLLDtO77EqmZ5la7cUgRDj4AY7Ua+MzubBZaovOqDYzAey7TDWLRXFDNIzzTgQAyHHrETZHGqwJx" & _
"MAEapYGqYpVi2HwzDuQ5oHKIQgggSSUGMOgdE4RhYDwJBVAwIQTH2UYhjQJBRAmZxuCEHZ3icJp5EgKxgAIVgCCQSQSEIBQkCAYhCAIJYKmKNIuFcTBIESPYEk6GBUm+" & _
"BZOmOPgZgWYRTiYEwvEwaIEAAK4KnKOJrgmTpDjCbYJmKSI2CoOxihOLglCuAACioNg8COA4gmcOZOiidg+g+Dh4moOA8CMYokNmCoyiycQ8E8A4iE6D4OjOMgng8ZJj" & _
"iITA8CSEouEcKwKkkLJyhQIoIkYU9LjORhcCsAAIACLQ8iaSJ6FKC5jJoaobA8KYoACCRKnmMJzhuDpZnSboMCKGJ4nMPIPDmYAACwKIDk6CoLCeU40m6I5oliMoKDya" & _
"ICokLIpgoThviOKJoGYf4KmUKhMjMLJLCAAojCyaYoiYGoGmqM46CkOwPEoKonAACxKlSdItmiWBeBeDgrioNo3D0KxSlAAAtgsUpYnUPRPEoco8hCa+T40SxbBRj5tE" & _
"sHJ1i6JhbGYS4ug8awelQLZAAKZI5C4DxrhYQ9ehmUppWiA48nAPRuFKYpiAAC47laZQ9iuKZSgOPotkuFI7C6C4gACPJAm8eQOhOQZoikDp3kCS5AACPoEk8fBGnqQg" & _
"pDOSppD2TxjlyPZD6CfwekQTx5lKP5ImseZTCAL5MAMAAAkoTADmMLpIjISp+HSS4PgyMAADBzAHDSIoPCOUpWjObIKE8NJOHKIwPEaTprBsHpdjWLB9AieQ+DQYwQAA" & _
"MR1EOZxWi+bx7HcWQ8msfRYnnDZQACRwxgwc5rGaMZPE0ZxqjWNZtgyRwAAyTZEnuXJzEyAx2kQcxNkye5cEy3cYAcANrGAIH4OAhx3gNGGPAfgIR8jBA4McBMARVhnH" & _
"4HQOYmxuCpF2MsecEQVBvGQCcIQug6itGQBoARAQ="
End With
.EndUpdate
End With
|
|
140
|
How can I arrange the month's header ( first month only, prev month, next, prev year, picture, ebn, expression)
With Calendar1
.BeginUpdate
.Appearance = None2
.Background(exDateHeader) = .BackColor
.FirstDay = Monday
.MaxMonthX = 2
.MaxMonthY = 2
.DrawGridLine = Solid
.WeekDays = "Su Mo Tu We Th Fr Sa"
.MarkToday = True
.AutoSize = exFixedSize
.AlignmentDay = CenterAlignment
.FixedCellHeight = 32
.FixedCellWidth = 32
.DateHeaderFormat = "( x = 0 and y = 0 ) ? `(2[b=0][bg=0x01000000]/3[b=0][bg=0x01000000]):32,1`: `1`"
.DateHeaderField(exHeaderDate) = " ( ( ( month(value) = month(date(``) ) and ( year(value) = year(date(``) ) ) ) ) ? `<b><fgcolor=0000FF>` : `` ) + `<c><%month%>" & _
" <%year%>`"
.HTMLPicture("up") = "gCJKBOI4NBQaBQAhQNJJIIhShQACERCAIA0RD7zf5hiJZJJEIJUPDaMZkUAQGAOP4DRShOgvHIGQA0U5CbKzOIZYRIICzCaUX4PS4hRgEGg/QaKJLhGSESIIZoMfAMM" & _
"IkKQzJxDDBJaCMaoQSABVhAXgQRBLRFdNhIB4QY4PfyUJB7AYAFo+DIWOb7LDdiIAJJFJxEVxCMCCgIA="
.HTMLPicture("down") = "gCJKBOI4NBQaBQAhQNJJIIhShQACERCAIA0RD7zf5hiIEM5BJpBhSxR4LfhhAsRKZJIhBKg4J7tRjJBIAEAMAjzWIJba0E5rWQcWaBAoFR7oK4HewRZCMPiMUDLXRoS" & _
"4PfjCQJrEhdaJ5ET4YIvTgOJ5kFSTKpkFaTKLEFqTGxyFgTIyuMgCeJaPwDSIKEhlCT5ZoWFT4iIAJJFJxEVxCMCCgIA="
.HTMLPicture("left") = "gCJKBOI4NBQaBQAhQNJJIIhShQACERCAIA0RD7zf5hiJUJJEIJUPDaMZkEANWACeJvMgBIwSGgXAaxGIQI6RMYAJBzFQQHYBeIzKQNYCpTIYAbwNQmMgAILNfAMEBKG" & _
"YuAaIaxMGYDFD2ARVASRNBDNCeSAIDRCW7MAgDDDZDIAKbADgRVrfUCNiIAJJFJxEVxCMCCgI"
.HTMLPicture("right") = "gCJKBOI4NBQaBQAhQNJJIIhShQACERCAIA0RD7zf5hiIBOZSI5CACuZwcdMRAhnIJNIMKWKPBb8MIFiIJOBILJzhQOYc7YYBY5vVBkiJEJJEIJUHBPMbAARYUI0KKAD" & _
"JKEaDEpAVgAYjHYI8GSACgQb4AcRiGCPJgwNQIEzANIICaUUwpUDIBYjKIzBAsAZiWQ1QYABLZTKBAIATL2CUxXJdV8RABJIpOIiuIRgQUBA="
.DateHeaderField(exHeaderPrevMonth) = "<c><img>up</img>"
.DateHeaderField(exHeaderNextMonth) = "<c><img>down</img>"
.DateHeaderField(exHeaderPrevYear) = "<c><img>left</img>"
.DateHeaderField(exHeaderNextYear) = "<c><img>right</img>"
With .VisualAppearance
.Add 1,"gBFLBCJwBAEHhEJAAEhABFgDg6AADACAxSDEMQBQKAAzQFAYbhgHCGAAGQaBUgmFgAQhFcZQSKUOQTDKMIziYBYfgkMIgSbJUgDGAkRRdDSOYIkWA5AiKEYoThCIxzT" & _
"J8aw3CKbYRAKCXfoUAJFP7Fc6ABJMBx3EyhZ89NDYEwTIKBahoehqIheEQyDSJNb2DCIahhMSEbKtCooDhGFpUWzLdxTJJVawHJoABjkS45PjEAJ+SBPUZVRRlFyfO7B" & _
"KSjMKKXgkG4zABWVa1bC1FzxQ6mKykKQLQADDIDVZAeL3JTNCS5IyLLDtO77EqmZ5la7cUgRDj4AY7Ua+MzubBZaovOqDYzAey7TDWLRXFDNIzzTgQAyHHrETZHGqwJx" & _
"MAEapYGqYpVi2HwzDuQ5oHKIQgggSSUGMOgdE4RhYDwJBVAwIQTH2UYhjQJBRAmZxuCEHZ3icJp5EgKxgAIVgCCQSQSEIBQkCAYhCAIJYKmKNIuFcTBIESPYEk6GBUm+" & _
"BZOmOPgZgWYRTiYEwvEwaIEAAK4KnKOJrgmTpDjCbYJmKSI2CoOxihOLglCuAACioNg8COA4gmcOZOiidg+g+Dh4moOA8CMYokNmCoyiycQ8E8A4iE6D4OjOMgng8ZJj" & _
"iITA8CSEouEcKwKkkLJyhQIoIkYU9LjORhcCsAAIACLQ8iaSJ6FKC5jJoaobA8KYoACCRKnmMJzhuDpZnSboMCKGJ4nMPIPDmYAACwKIDk6CoLCeU40m6I5oliMoKDya" & _
"ICokLIpgoThviOKJoGYf4KmUKhMjMLJLCAAojCyaYoiYGoGmqM46CkOwPEoKonAACxKlSdItmiWBeBeDgrioNo3D0KxSlAAAtgsUpYnUPRPEoco8hCa+T40SxbBRj5tE" & _
"sHJ1i6JhbGYS4ug8awelQLZAAKZI5C4DxrhYQ9ehmUppWiA48nAPRuFKYpiAAC47laZQ9iuKZSgOPotkuFI7C6C4gACPJAm8eQOhOQZoikDp3kCS5AACPoEk8fBGnqQg" & _
"pDOSppD2TxjlyPZD6CfwekQTx5lKP5ImseZTCAL5MAMAAAkoTADmMLpIjISp+HSS4PgyMAADBzAHDSIoPCOUpWjObIKE8NJOHKIwPEaTprBsHpdjWLB9AieQ+DQYwQAA" & _
"MR1EOZxWi+bx7HcWQ8msfRYnnDZQACRwxgwc5rGaMZPE0ZxqjWNZtgyRwAAyTZEnuXJzEyAx2kQcxNkye5cEy3cYAcANrGAIH4OAhx3gNGGPAfgIR8jBA4McBMARVhnH" & _
"4HQOYmxuCpF2MsecEQVBvGQCcIQug6itGQBoARAQ="
End With
.EndUpdate
End With
|
|
139
|
How can I arrange the month's header ( all, left, right, prev month, next, prev year, picture, ebn)
With Calendar1
.BeginUpdate
.Appearance = None2
.Background(exDateHeader) = .BackColor
.FirstDay = Monday
.MaxMonthX = 2
.MaxMonthY = 2
.DrawGridLine = Solid
.WeekDays = "Su Mo Tu We Th Fr Sa"
.MarkToday = True
.AutoSize = exFixedSize
.AlignmentDay = CenterAlignment
.FixedCellHeight = 32
.FixedCellWidth = 32
.DateHeaderFormat = "(2[b=0][bg=0x01000000]/4[b=0][bg=0x01000000]):32,1,(3[b=0][bg=0x01000000]/5[b=0][bg=0x01000000]):32"
.DateHeaderField(exHeaderDate) = " ( ( ( month(value) = month(date(``) ) and ( year(value) = year(date(``) ) ) ) ) ? `<b><fgcolor=0000FF>` : `` ) + `<c><%month%>" & _
" <%year%>`"
.HTMLPicture("up") = "gCJKBOI4NBQaBQAhQNJJIIhShQACERCAIA0RD7zf5hiJZJJEIJUPDaMZkUAQGAOP4DRShOgvHIGQA0U5CbKzOIZYRIICzCaUX4PS4hRgEGg/QaKJLhGSESIIZoMfAMM" & _
"IkKQzJxDDBJaCMaoQSABVhAXgQRBLRFdNhIB4QY4PfyUJB7AYAFo+DIWOb7LDdiIAJJFJxEVxCMCCgIA="
.HTMLPicture("down") = "gCJKBOI4NBQaBQAhQNJJIIhShQACERCAIA0RD7zf5hiIEM5BJpBhSxR4LfhhAsRKZJIhBKg4J7tRjJBIAEAMAjzWIJba0E5rWQcWaBAoFR7oK4HewRZCMPiMUDLXRoS" & _
"4PfjCQJrEhdaJ5ET4YIvTgOJ5kFSTKpkFaTKLEFqTGxyFgTIyuMgCeJaPwDSIKEhlCT5ZoWFT4iIAJJFJxEVxCMCCgIA="
.HTMLPicture("left") = "gCJKBOI4NBQaBQAhQNJJIIhShQACERCAIA0RD7zf5hiJUJJEIJUPDaMZkEANWACeJvMgBIwSGgXAaxGIQI6RMYAJBzFQQHYBeIzKQNYCpTIYAbwNQmMgAILNfAMEBKG" & _
"YuAaIaxMGYDFD2ARVASRNBDNCeSAIDRCW7MAgDDDZDIAKbADgRVrfUCNiIAJJFJxEVxCMCCgI"
.HTMLPicture("right") = "gCJKBOI4NBQaBQAhQNJJIIhShQACERCAIA0RD7zf5hiIBOZSI5CACuZwcdMRAhnIJNIMKWKPBb8MIFiIJOBILJzhQOYc7YYBY5vVBkiJEJJEIJUHBPMbAARYUI0KKAD" & _
"JKEaDEpAVgAYjHYI8GSACgQb4AcRiGCPJgwNQIEzANIICaUUwpUDIBYjKIzBAsAZiWQ1QYABLZTKBAIATL2CUxXJdV8RABJIpOIiuIRgQUBA="
.DateHeaderField(exHeaderPrevMonth) = "<c><img>up</img>"
.DateHeaderField(exHeaderNextMonth) = "<c><img>down</img>"
.DateHeaderField(exHeaderPrevYear) = "<c><img>left</img>"
.DateHeaderField(exHeaderNextYear) = "<c><img>right</img>"
With .VisualAppearance
.Add 1,"gBFLBCJwBAEHhEJAAEhABFgDg6AADACAxSDEMQBQKAAzQFAYbhgHCGAAGQaBUgmFgAQhFcZQSKUOQTDKMIziYBYfgkMIgSbJUgDGAkRRdDSOYIkWA5AiKEYoThCIxzT" & _
"J8aw3CKbYRAKCXfoUAJFP7Fc6ABJMBx3EyhZ89NDYEwTIKBahoehqIheEQyDSJNb2DCIahhMSEbKtCooDhGFpUWzLdxTJJVawHJoABjkS45PjEAJ+SBPUZVRRlFyfO7B" & _
"KSjMKKXgkG4zABWVa1bC1FzxQ6mKykKQLQADDIDVZAeL3JTNCS5IyLLDtO77EqmZ5la7cUgRDj4AY7Ua+MzubBZaovOqDYzAey7TDWLRXFDNIzzTgQAyHHrETZHGqwJx" & _
"MAEapYGqYpVi2HwzDuQ5oHKIQgggSSUGMOgdE4RhYDwJBVAwIQTH2UYhjQJBRAmZxuCEHZ3icJp5EgKxgAIVgCCQSQSEIBQkCAYhCAIJYKmKNIuFcTBIESPYEk6GBUm+" & _
"BZOmOPgZgWYRTiYEwvEwaIEAAK4KnKOJrgmTpDjCbYJmKSI2CoOxihOLglCuAACioNg8COA4gmcOZOiidg+g+Dh4moOA8CMYokNmCoyiycQ8E8A4iE6D4OjOMgng8ZJj" & _
"iITA8CSEouEcKwKkkLJyhQIoIkYU9LjORhcCsAAIACLQ8iaSJ6FKC5jJoaobA8KYoACCRKnmMJzhuDpZnSboMCKGJ4nMPIPDmYAACwKIDk6CoLCeU40m6I5oliMoKDya" & _
"ICokLIpgoThviOKJoGYf4KmUKhMjMLJLCAAojCyaYoiYGoGmqM46CkOwPEoKonAACxKlSdItmiWBeBeDgrioNo3D0KxSlAAAtgsUpYnUPRPEoco8hCa+T40SxbBRj5tE" & _
"sHJ1i6JhbGYS4ug8awelQLZAAKZI5C4DxrhYQ9ehmUppWiA48nAPRuFKYpiAAC47laZQ9iuKZSgOPotkuFI7C6C4gACPJAm8eQOhOQZoikDp3kCS5AACPoEk8fBGnqQg" & _
"pDOSppD2TxjlyPZD6CfwekQTx5lKP5ImseZTCAL5MAMAAAkoTADmMLpIjISp+HSS4PgyMAADBzAHDSIoPCOUpWjObIKE8NJOHKIwPEaTprBsHpdjWLB9AieQ+DQYwQAA" & _
"MR1EOZxWi+bx7HcWQ8msfRYnnDZQACRwxgwc5rGaMZPE0ZxqjWNZtgyRwAAyTZEnuXJzEyAx2kQcxNkye5cEy3cYAcANrGAIH4OAhx3gNGGPAfgIR8jBA4McBMARVhnH" & _
"4HQOYmxuCpF2MsecEQVBvGQCcIQug6itGQBoARAQ="
End With
.EndUpdate
End With
|
|
138
|
How can I arrange the month's header ( all, left, right, prev month, next, prev year, picture, ebn)
With Calendar1
.BeginUpdate
.Appearance = None2
.Background(exDateHeader) = .BackColor
.FirstDay = Monday
.MaxMonthX = 2
.MaxMonthY = 2
.DrawGridLine = Solid
.WeekDays = "Su Mo Tu We Th Fr Sa"
.MarkToday = True
.AutoSize = exFixedSize
.AlignmentDay = CenterAlignment
.FixedCellHeight = 32
.FixedCellWidth = 32
.DateHeaderFormat = "2[b=0][bg=0x01000000]:32,3[b=0][bg=0x01000000]:32,1,4[b=0][bg=0x01000000]:32,5[b=0][bg=0x01000000]:32"
.DateHeaderField(exHeaderDate) = " ( ( ( month(value) = month(date(``) ) and ( year(value) = year(date(``) ) ) ) ) ? `<b><fgcolor=0000FF>` : `` ) + `<c><%month%>" & _
" <%year%>`"
.HTMLPicture("up") = "gCJKBOI4NBQaBQAhQNJJIIhShQACERCAIA0RD7zf5hiJZJJEIJUPDaMZkUAQGAOP4DRShOgvHIGQA0U5CbKzOIZYRIICzCaUX4PS4hRgEGg/QaKJLhGSESIIZoMfAMM" & _
"IkKQzJxDDBJaCMaoQSABVhAXgQRBLRFdNhIB4QY4PfyUJB7AYAFo+DIWOb7LDdiIAJJFJxEVxCMCCgIA="
.HTMLPicture("down") = "gCJKBOI4NBQaBQAhQNJJIIhShQACERCAIA0RD7zf5hiIEM5BJpBhSxR4LfhhAsRKZJIhBKg4J7tRjJBIAEAMAjzWIJba0E5rWQcWaBAoFR7oK4HewRZCMPiMUDLXRoS" & _
"4PfjCQJrEhdaJ5ET4YIvTgOJ5kFSTKpkFaTKLEFqTGxyFgTIyuMgCeJaPwDSIKEhlCT5ZoWFT4iIAJJFJxEVxCMCCgIA="
.HTMLPicture("left") = "gCJKBOI4NBQaBQAhQNJJIIhShQACERCAIA0RD7zf5hiJUJJEIJUPDaMZkEANWACeJvMgBIwSGgXAaxGIQI6RMYAJBzFQQHYBeIzKQNYCpTIYAbwNQmMgAILNfAMEBKG" & _
"YuAaIaxMGYDFD2ARVASRNBDNCeSAIDRCW7MAgDDDZDIAKbADgRVrfUCNiIAJJFJxEVxCMCCgI"
.HTMLPicture("right") = "gCJKBOI4NBQaBQAhQNJJIIhShQACERCAIA0RD7zf5hiIBOZSI5CACuZwcdMRAhnIJNIMKWKPBb8MIFiIJOBILJzhQOYc7YYBY5vVBkiJEJJEIJUHBPMbAARYUI0KKAD" & _
"JKEaDEpAVgAYjHYI8GSACgQb4AcRiGCPJgwNQIEzANIICaUUwpUDIBYjKIzBAsAZiWQ1QYABLZTKBAIATL2CUxXJdV8RABJIpOIiuIRgQUBA="
.DateHeaderField(exHeaderPrevMonth) = "<c><img>up</img>"
.DateHeaderField(exHeaderNextMonth) = "<c><img>down</img>"
.DateHeaderField(exHeaderPrevYear) = "<c><img>left</img>"
.DateHeaderField(exHeaderNextYear) = "<c><img>right</img>"
With .VisualAppearance
.Add 1,"gBFLBCJwBAEHhEJAAEhABFgDg6AADACAxSDEMQBQKAAzQFAYbhgHCGAAGQaBUgmFgAQhFcZQSKUOQTDKMIziYBYfgkMIgSbJUgDGAkRRdDSOYIkWA5AiKEYoThCIxzT" & _
"J8aw3CKbYRAKCXfoUAJFP7Fc6ABJMBx3EyhZ89NDYEwTIKBahoehqIheEQyDSJNb2DCIahhMSEbKtCooDhGFpUWzLdxTJJVawHJoABjkS45PjEAJ+SBPUZVRRlFyfO7B" & _
"KSjMKKXgkG4zABWVa1bC1FzxQ6mKykKQLQADDIDVZAeL3JTNCS5IyLLDtO77EqmZ5la7cUgRDj4AY7Ua+MzubBZaovOqDYzAey7TDWLRXFDNIzzTgQAyHHrETZHGqwJx" & _
"MAEapYGqYpVi2HwzDuQ5oHKIQgggSSUGMOgdE4RhYDwJBVAwIQTH2UYhjQJBRAmZxuCEHZ3icJp5EgKxgAIVgCCQSQSEIBQkCAYhCAIJYKmKNIuFcTBIESPYEk6GBUm+" & _
"BZOmOPgZgWYRTiYEwvEwaIEAAK4KnKOJrgmTpDjCbYJmKSI2CoOxihOLglCuAACioNg8COA4gmcOZOiidg+g+Dh4moOA8CMYokNmCoyiycQ8E8A4iE6D4OjOMgng8ZJj" & _
"iITA8CSEouEcKwKkkLJyhQIoIkYU9LjORhcCsAAIACLQ8iaSJ6FKC5jJoaobA8KYoACCRKnmMJzhuDpZnSboMCKGJ4nMPIPDmYAACwKIDk6CoLCeU40m6I5oliMoKDya" & _
"ICokLIpgoThviOKJoGYf4KmUKhMjMLJLCAAojCyaYoiYGoGmqM46CkOwPEoKonAACxKlSdItmiWBeBeDgrioNo3D0KxSlAAAtgsUpYnUPRPEoco8hCa+T40SxbBRj5tE" & _
"sHJ1i6JhbGYS4ug8awelQLZAAKZI5C4DxrhYQ9ehmUppWiA48nAPRuFKYpiAAC47laZQ9iuKZSgOPotkuFI7C6C4gACPJAm8eQOhOQZoikDp3kCS5AACPoEk8fBGnqQg" & _
"pDOSppD2TxjlyPZD6CfwekQTx5lKP5ImseZTCAL5MAMAAAkoTADmMLpIjISp+HSS4PgyMAADBzAHDSIoPCOUpWjObIKE8NJOHKIwPEaTprBsHpdjWLB9AieQ+DQYwQAA" & _
"MR1EOZxWi+bx7HcWQ8msfRYnnDZQACRwxgwc5rGaMZPE0ZxqjWNZtgyRwAAyTZEnuXJzEyAx2kQcxNkye5cEy3cYAcANrGAIH4OAhx3gNGGPAfgIR8jBA4McBMARVhnH" & _
"4HQOYmxuCpF2MsecEQVBvGQCcIQug6itGQBoARAQ="
End With
.EndUpdate
End With
|
|
137
|
How can I arrange the month's header ( left, right, prev month, next, prev year, picture, ebn)
With Calendar1
.BeginUpdate
.Appearance = None2
.Background(exDateHeader) = .BackColor
.FirstDay = Monday
.MaxMonthX = 2
.MaxMonthY = 2
.DrawGridLine = Solid
.WeekDays = "Su Mo Tu We Th Fr Sa"
.MarkToday = True
.AutoSize = exFixedSize
.AlignmentDay = CenterAlignment
.FixedCellHeight = 32
.FixedCellWidth = 32
.DateHeaderFormat = "(2[b=0][bg=0x01000000]/3[b=0][bg=0x01000000]):32,1,(4[b=0][bg=0x01000000]/5[b=0][bg=0x01000000]):32"
.DateHeaderField(exHeaderDate) = " ( ( ( month(value) = month(date(``) ) and ( year(value) = year(date(``) ) ) ) ) ? `<b><fgcolor=0000FF>` : `` ) + `<c><%month%>" & _
" <%year%>`"
.HTMLPicture("up") = "gCJKBOI4NBQaBQAhQNJJIIhShQACERCAIA0RD7zf5hiJZJJEIJUPDaMZkUAQGAOP4DRShOgvHIGQA0U5CbKzOIZYRIICzCaUX4PS4hRgEGg/QaKJLhGSESIIZoMfAMM" & _
"IkKQzJxDDBJaCMaoQSABVhAXgQRBLRFdNhIB4QY4PfyUJB7AYAFo+DIWOb7LDdiIAJJFJxEVxCMCCgIA="
.HTMLPicture("down") = "gCJKBOI4NBQaBQAhQNJJIIhShQACERCAIA0RD7zf5hiIEM5BJpBhSxR4LfhhAsRKZJIhBKg4J7tRjJBIAEAMAjzWIJba0E5rWQcWaBAoFR7oK4HewRZCMPiMUDLXRoS" & _
"4PfjCQJrEhdaJ5ET4YIvTgOJ5kFSTKpkFaTKLEFqTGxyFgTIyuMgCeJaPwDSIKEhlCT5ZoWFT4iIAJJFJxEVxCMCCgIA="
.HTMLPicture("left") = "gCJKBOI4NBQaBQAhQNJJIIhShQACERCAIA0RD7zf5hiJUJJEIJUPDaMZkEANWACeJvMgBIwSGgXAaxGIQI6RMYAJBzFQQHYBeIzKQNYCpTIYAbwNQmMgAILNfAMEBKG" & _
"YuAaIaxMGYDFD2ARVASRNBDNCeSAIDRCW7MAgDDDZDIAKbADgRVrfUCNiIAJJFJxEVxCMCCgI"
.HTMLPicture("right") = "gCJKBOI4NBQaBQAhQNJJIIhShQACERCAIA0RD7zf5hiIBOZSI5CACuZwcdMRAhnIJNIMKWKPBb8MIFiIJOBILJzhQOYc7YYBY5vVBkiJEJJEIJUHBPMbAARYUI0KKAD" & _
"JKEaDEpAVgAYjHYI8GSACgQb4AcRiGCPJgwNQIEzANIICaUUwpUDIBYjKIzBAsAZiWQ1QYABLZTKBAIATL2CUxXJdV8RABJIpOIiuIRgQUBA="
.DateHeaderField(exHeaderPrevMonth) = "<c><img>up</img>"
.DateHeaderField(exHeaderNextMonth) = "<c><img>down</img>"
.DateHeaderField(exHeaderPrevYear) = "<c><img>left</img>"
.DateHeaderField(exHeaderNextYear) = "<c><img>right</img>"
With .VisualAppearance
.Add 1,"gBFLBCJwBAEHhEJAAEhABFgDg6AADACAxSDEMQBQKAAzQFAYbhgHCGAAGQaBUgmFgAQhFcZQSKUOQTDKMIziYBYfgkMIgSbJUgDGAkRRdDSOYIkWA5AiKEYoThCIxzT" & _
"J8aw3CKbYRAKCXfoUAJFP7Fc6ABJMBx3EyhZ89NDYEwTIKBahoehqIheEQyDSJNb2DCIahhMSEbKtCooDhGFpUWzLdxTJJVawHJoABjkS45PjEAJ+SBPUZVRRlFyfO7B" & _
"KSjMKKXgkG4zABWVa1bC1FzxQ6mKykKQLQADDIDVZAeL3JTNCS5IyLLDtO77EqmZ5la7cUgRDj4AY7Ua+MzubBZaovOqDYzAey7TDWLRXFDNIzzTgQAyHHrETZHGqwJx" & _
"MAEapYGqYpVi2HwzDuQ5oHKIQgggSSUGMOgdE4RhYDwJBVAwIQTH2UYhjQJBRAmZxuCEHZ3icJp5EgKxgAIVgCCQSQSEIBQkCAYhCAIJYKmKNIuFcTBIESPYEk6GBUm+" & _
"BZOmOPgZgWYRTiYEwvEwaIEAAK4KnKOJrgmTpDjCbYJmKSI2CoOxihOLglCuAACioNg8COA4gmcOZOiidg+g+Dh4moOA8CMYokNmCoyiycQ8E8A4iE6D4OjOMgng8ZJj" & _
"iITA8CSEouEcKwKkkLJyhQIoIkYU9LjORhcCsAAIACLQ8iaSJ6FKC5jJoaobA8KYoACCRKnmMJzhuDpZnSboMCKGJ4nMPIPDmYAACwKIDk6CoLCeU40m6I5oliMoKDya" & _
"ICokLIpgoThviOKJoGYf4KmUKhMjMLJLCAAojCyaYoiYGoGmqM46CkOwPEoKonAACxKlSdItmiWBeBeDgrioNo3D0KxSlAAAtgsUpYnUPRPEoco8hCa+T40SxbBRj5tE" & _
"sHJ1i6JhbGYS4ug8awelQLZAAKZI5C4DxrhYQ9ehmUppWiA48nAPRuFKYpiAAC47laZQ9iuKZSgOPotkuFI7C6C4gACPJAm8eQOhOQZoikDp3kCS5AACPoEk8fBGnqQg" & _
"pDOSppD2TxjlyPZD6CfwekQTx5lKP5ImseZTCAL5MAMAAAkoTADmMLpIjISp+HSS4PgyMAADBzAHDSIoPCOUpWjObIKE8NJOHKIwPEaTprBsHpdjWLB9AieQ+DQYwQAA" & _
"MR1EOZxWi+bx7HcWQ8msfRYnnDZQACRwxgwc5rGaMZPE0ZxqjWNZtgyRwAAyTZEnuXJzEyAx2kQcxNkye5cEy3cYAcANrGAIH4OAhx3gNGGPAfgIR8jBA4McBMARVhnH" & _
"4HQOYmxuCpF2MsecEQVBvGQCcIQug6itGQBoARAQ="
End With
.EndUpdate
End With
|
|
136
|
How can I arrange the month's header ( down, next, prev month, next, prev year, picture, ebn)
With Calendar1
.BeginUpdate
.Appearance = None2
.Background(exDateHeader) = .BackColor
.FirstDay = Monday
.MaxMonthX = 2
.MaxMonthY = 2
.DrawGridLine = Solid
.WeekDays = "Su Mo Tu We Th Fr Sa"
.MarkToday = True
.AutoSize = exFixedSize
.AlignmentDay = CenterAlignment
.FixedCellHeight = 32
.FixedCellWidth = 32
.DateHeaderFormat = "1/16;(2[bg=0x01808080],3[bg=0x01000000])[b=15],(4[bg=0x01808080],5[bg=0x01000000])[b=15]"
.DateHeaderField(exHeaderDate) = " ( ( ( month(value) = month(date(``) ) and ( year(value) = year(date(``) ) ) ) ) ? `<b><fgcolor=0000FF>` : `` ) + `<c><%month%>" & _
" <%year%>`"
.HTMLPicture("up") = "gCJKBOI4NBQaBQAhQNJJIIhShQACERCAIA0RD7zf5hiJZJJEIJUPDaMZkUAQGAOP4DRShOgvHIGQA0U5CbKzOIZYRIICzCaUX4PS4hRgEGg/QaKJLhGSESIIZoMfAMM" & _
"IkKQzJxDDBJaCMaoQSABVhAXgQRBLRFdNhIB4QY4PfyUJB7AYAFo+DIWOb7LDdiIAJJFJxEVxCMCCgIA="
.HTMLPicture("down") = "gCJKBOI4NBQaBQAhQNJJIIhShQACERCAIA0RD7zf5hiIEM5BJpBhSxR4LfhhAsRKZJIhBKg4J7tRjJBIAEAMAjzWIJba0E5rWQcWaBAoFR7oK4HewRZCMPiMUDLXRoS" & _
"4PfjCQJrEhdaJ5ET4YIvTgOJ5kFSTKpkFaTKLEFqTGxyFgTIyuMgCeJaPwDSIKEhlCT5ZoWFT4iIAJJFJxEVxCMCCgIA="
.HTMLPicture("left") = "gCJKBOI4NBQaBQAhQNJJIIhShQACERCAIA0RD7zf5hiJUJJEIJUPDaMZkEANWACeJvMgBIwSGgXAaxGIQI6RMYAJBzFQQHYBeIzKQNYCpTIYAbwNQmMgAILNfAMEBKG" & _
"YuAaIaxMGYDFD2ARVASRNBDNCeSAIDRCW7MAgDDDZDIAKbADgRVrfUCNiIAJJFJxEVxCMCCgI"
.HTMLPicture("right") = "gCJKBOI4NBQaBQAhQNJJIIhShQACERCAIA0RD7zf5hiIBOZSI5CACuZwcdMRAhnIJNIMKWKPBb8MIFiIJOBILJzhQOYc7YYBY5vVBkiJEJJEIJUHBPMbAARYUI0KKAD" & _
"JKEaDEpAVgAYjHYI8GSACgQb4AcRiGCPJgwNQIEzANIICaUUwpUDIBYjKIzBAsAZiWQ1QYABLZTKBAIATL2CUxXJdV8RABJIpOIiuIRgQUBA="
.DateHeaderField(exHeaderPrevMonth) = "<c><img>up</img>"
.DateHeaderField(exHeaderNextMonth) = "<c><img>down</img>"
.DateHeaderField(exHeaderPrevYear) = "<c><img>left</img>"
.DateHeaderField(exHeaderNextYear) = "<c><img>right</img>"
With .VisualAppearance
.Add 1,"gBFLBCJwBAEHhEJAAEhABFgDg6AADACAxSDEMQBQKAAzQFAYbhgHCGAAGQaBUgmFgAQhFcZQSKUOQTDKMIziYBYfgkMIgSbJUgDGAkRRdDSOYIkWA5AiKEYoThCIxzT" & _
"J8aw3CKbYRAKCXfoUAJFP7Fc6ABJMBx3EyhZ89NDYEwTIKBahoehqIheEQyDSJNb2DCIahhMSEbKtCooDhGFpUWzLdxTJJVawHJoABjkS45PjEAJ+SBPUZVRRlFyfO7B" & _
"KSjMKKXgkG4zABWVa1bC1FzxQ6mKykKQLQADDIDVZAeL3JTNCS5IyLLDtO77EqmZ5la7cUgRDj4AY7Ua+MzubBZaovOqDYzAey7TDWLRXFDNIzzTgQAyHHrETZHGqwJx" & _
"MAEapYGqYpVi2HwzDuQ5oHKIQgggSSUGMOgdE4RhYDwJBVAwIQTH2UYhjQJBRAmZxuCEHZ3icJp5EgKxgAIVgCCQSQSEIBQkCAYhCAIJYKmKNIuFcTBIESPYEk6GBUm+" & _
"BZOmOPgZgWYRTiYEwvEwaIEAAK4KnKOJrgmTpDjCbYJmKSI2CoOxihOLglCuAACioNg8COA4gmcOZOiidg+g+Dh4moOA8CMYokNmCoyiycQ8E8A4iE6D4OjOMgng8ZJj" & _
"iITA8CSEouEcKwKkkLJyhQIoIkYU9LjORhcCsAAIACLQ8iaSJ6FKC5jJoaobA8KYoACCRKnmMJzhuDpZnSboMCKGJ4nMPIPDmYAACwKIDk6CoLCeU40m6I5oliMoKDya" & _
"ICokLIpgoThviOKJoGYf4KmUKhMjMLJLCAAojCyaYoiYGoGmqM46CkOwPEoKonAACxKlSdItmiWBeBeDgrioNo3D0KxSlAAAtgsUpYnUPRPEoco8hCa+T40SxbBRj5tE" & _
"sHJ1i6JhbGYS4ug8awelQLZAAKZI5C4DxrhYQ9ehmUppWiA48nAPRuFKYpiAAC47laZQ9iuKZSgOPotkuFI7C6C4gACPJAm8eQOhOQZoikDp3kCS5AACPoEk8fBGnqQg" & _
"pDOSppD2TxjlyPZD6CfwekQTx5lKP5ImseZTCAL5MAMAAAkoTADmMLpIjISp+HSS4PgyMAADBzAHDSIoPCOUpWjObIKE8NJOHKIwPEaTprBsHpdjWLB9AieQ+DQYwQAA" & _
"MR1EOZxWi+bx7HcWQ8msfRYnnDZQACRwxgwc5rGaMZPE0ZxqjWNZtgyRwAAyTZEnuXJzEyAx2kQcxNkye5cEy3cYAcANrGAIH4OAhx3gNGGPAfgIR8jBA4McBMARVhnH" & _
"4HQOYmxuCpF2MsecEQVBvGQCcIQug6itGQBoARAQ="
End With
.EndUpdate
End With
|
|
135
|
How can I arrange the month's header ( down, next, prev month, picture, ebn)
With Calendar1
.BeginUpdate
.Appearance = None2
.Background(exDateHeader) = .BackColor
.FirstDay = Monday
.MaxMonthX = 2
.MaxMonthY = 2
.DrawGridLine = Solid
.WeekDays = "Su Mo Tu We Th Fr Sa"
.MarkToday = True
.AutoSize = exFixedSize
.AlignmentDay = CenterAlignment
.FixedCellHeight = 32
.FixedCellWidth = 32
.DateHeaderFormat = "1/16;2[b=0][bg=0x01000000],3[b=0][bg=0x01000000]"
.DateHeaderField(exHeaderDate) = " ( ( ( month(value) = month(date(``) ) and ( year(value) = year(date(``) ) ) ) ) ? `<b><fgcolor=0000FF>` : `` ) + `<c><%month%>" & _
" <%year%>`"
.HTMLPicture("up") = "gCJKBOI4NBQaBQAhQNJJIIhShQACERCAIA0RD7zf5hiJZJJEIJUPDaMZkUAQGAOP4DRShOgvHIGQA0U5CbKzOIZYRIICzCaUX4PS4hRgEGg/QaKJLhGSESIIZoMfAMM" & _
"IkKQzJxDDBJaCMaoQSABVhAXgQRBLRFdNhIB4QY4PfyUJB7AYAFo+DIWOb7LDdiIAJJFJxEVxCMCCgIA="
.HTMLPicture("down") = "gCJKBOI4NBQaBQAhQNJJIIhShQACERCAIA0RD7zf5hiIEM5BJpBhSxR4LfhhAsRKZJIhBKg4J7tRjJBIAEAMAjzWIJba0E5rWQcWaBAoFR7oK4HewRZCMPiMUDLXRoS" & _
"4PfjCQJrEhdaJ5ET4YIvTgOJ5kFSTKpkFaTKLEFqTGxyFgTIyuMgCeJaPwDSIKEhlCT5ZoWFT4iIAJJFJxEVxCMCCgIA="
.HTMLPicture("left") = "gCJKBOI4NBQaBQAhQNJJIIhShQACERCAIA0RD7zf5hiJUJJEIJUPDaMZkEANWACeJvMgBIwSGgXAaxGIQI6RMYAJBzFQQHYBeIzKQNYCpTIYAbwNQmMgAILNfAMEBKG" & _
"YuAaIaxMGYDFD2ARVASRNBDNCeSAIDRCW7MAgDDDZDIAKbADgRVrfUCNiIAJJFJxEVxCMCCgI"
.HTMLPicture("right") = "gCJKBOI4NBQaBQAhQNJJIIhShQACERCAIA0RD7zf5hiIBOZSI5CACuZwcdMRAhnIJNIMKWKPBb8MIFiIJOBILJzhQOYc7YYBY5vVBkiJEJJEIJUHBPMbAARYUI0KKAD" & _
"JKEaDEpAVgAYjHYI8GSACgQb4AcRiGCPJgwNQIEzANIICaUUwpUDIBYjKIzBAsAZiWQ1QYABLZTKBAIATL2CUxXJdV8RABJIpOIiuIRgQUBA="
.DateHeaderField(exHeaderPrevMonth) = "<c><img>up</img>"
.DateHeaderField(exHeaderNextMonth) = "<c><img>down</img>"
.DateHeaderField(exHeaderPrevYear) = "<c><img>left</img>"
.DateHeaderField(exHeaderNextYear) = "<c><img>right</img>"
With .VisualAppearance
.Add 1,"gBFLBCJwBAEHhEJAAEhABFgDg6AADACAxSDEMQBQKAAzQFAYbhgHCGAAGQaBUgmFgAQhFcZQSKUOQTDKMIziYBYfgkMIgSbJUgDGAkRRdDSOYIkWA5AiKEYoThCIxzT" & _
"J8aw3CKbYRAKCXfoUAJFP7Fc6ABJMBx3EyhZ89NDYEwTIKBahoehqIheEQyDSJNb2DCIahhMSEbKtCooDhGFpUWzLdxTJJVawHJoABjkS45PjEAJ+SBPUZVRRlFyfO7B" & _
"KSjMKKXgkG4zABWVa1bC1FzxQ6mKykKQLQADDIDVZAeL3JTNCS5IyLLDtO77EqmZ5la7cUgRDj4AY7Ua+MzubBZaovOqDYzAey7TDWLRXFDNIzzTgQAyHHrETZHGqwJx" & _
"MAEapYGqYpVi2HwzDuQ5oHKIQgggSSUGMOgdE4RhYDwJBVAwIQTH2UYhjQJBRAmZxuCEHZ3icJp5EgKxgAIVgCCQSQSEIBQkCAYhCAIJYKmKNIuFcTBIESPYEk6GBUm+" & _
"BZOmOPgZgWYRTiYEwvEwaIEAAK4KnKOJrgmTpDjCbYJmKSI2CoOxihOLglCuAACioNg8COA4gmcOZOiidg+g+Dh4moOA8CMYokNmCoyiycQ8E8A4iE6D4OjOMgng8ZJj" & _
"iITA8CSEouEcKwKkkLJyhQIoIkYU9LjORhcCsAAIACLQ8iaSJ6FKC5jJoaobA8KYoACCRKnmMJzhuDpZnSboMCKGJ4nMPIPDmYAACwKIDk6CoLCeU40m6I5oliMoKDya" & _
"ICokLIpgoThviOKJoGYf4KmUKhMjMLJLCAAojCyaYoiYGoGmqM46CkOwPEoKonAACxKlSdItmiWBeBeDgrioNo3D0KxSlAAAtgsUpYnUPRPEoco8hCa+T40SxbBRj5tE" & _
"sHJ1i6JhbGYS4ug8awelQLZAAKZI5C4DxrhYQ9ehmUppWiA48nAPRuFKYpiAAC47laZQ9iuKZSgOPotkuFI7C6C4gACPJAm8eQOhOQZoikDp3kCS5AACPoEk8fBGnqQg" & _
"pDOSppD2TxjlyPZD6CfwekQTx5lKP5ImseZTCAL5MAMAAAkoTADmMLpIjISp+HSS4PgyMAADBzAHDSIoPCOUpWjObIKE8NJOHKIwPEaTprBsHpdjWLB9AieQ+DQYwQAA" & _
"MR1EOZxWi+bx7HcWQ8msfRYnnDZQACRwxgwc5rGaMZPE0ZxqjWNZtgyRwAAyTZEnuXJzEyAx2kQcxNkye5cEy3cYAcANrGAIH4OAhx3gNGGPAfgIR8jBA4McBMARVhnH" & _
"4HQOYmxuCpF2MsecEQVBvGQCcIQug6itGQBoARAQ="
End With
.EndUpdate
End With
|
|
134
|
How can I arrange the month's header ( left, right center, next, prev month, picture, ebn)
With Calendar1
.BeginUpdate
.Appearance = None2
.Background(exDateHeader) = .BackColor
.FirstDay = Monday
.MaxMonthX = 2
.MaxMonthY = 2
.DrawGridLine = Solid
.WeekDays = "Su Mo Tu We Th Fr Sa"
.MarkToday = True
.AutoSize = exFixedSize
.AlignmentDay = CenterAlignment
.FixedCellHeight = 32
.FixedCellWidth = 32
.DateHeaderFormat = "2[b=0][bg=0x01000000],1,3[b=0][bg=0x01000000]"
.DateHeaderField(exHeaderDate) = " ( ( ( month(value) = month(date(``) ) and ( year(value) = year(date(``) ) ) ) ) ? `<b><fgcolor=0000FF>` : `` ) + `<c><%month%>" & _
" <%year%>`"
.HTMLPicture("up") = "gCJKBOI4NBQaBQAhQNJJIIhShQACERCAIA0RD7zf5hiJZJJEIJUPDaMZkUAQGAOP4DRShOgvHIGQA0U5CbKzOIZYRIICzCaUX4PS4hRgEGg/QaKJLhGSESIIZoMfAMM" & _
"IkKQzJxDDBJaCMaoQSABVhAXgQRBLRFdNhIB4QY4PfyUJB7AYAFo+DIWOb7LDdiIAJJFJxEVxCMCCgIA="
.HTMLPicture("down") = "gCJKBOI4NBQaBQAhQNJJIIhShQACERCAIA0RD7zf5hiIEM5BJpBhSxR4LfhhAsRKZJIhBKg4J7tRjJBIAEAMAjzWIJba0E5rWQcWaBAoFR7oK4HewRZCMPiMUDLXRoS" & _
"4PfjCQJrEhdaJ5ET4YIvTgOJ5kFSTKpkFaTKLEFqTGxyFgTIyuMgCeJaPwDSIKEhlCT5ZoWFT4iIAJJFJxEVxCMCCgIA="
.HTMLPicture("left") = "gCJKBOI4NBQaBQAhQNJJIIhShQACERCAIA0RD7zf5hiJUJJEIJUPDaMZkEANWACeJvMgBIwSGgXAaxGIQI6RMYAJBzFQQHYBeIzKQNYCpTIYAbwNQmMgAILNfAMEBKG" & _
"YuAaIaxMGYDFD2ARVASRNBDNCeSAIDRCW7MAgDDDZDIAKbADgRVrfUCNiIAJJFJxEVxCMCCgI"
.HTMLPicture("right") = "gCJKBOI4NBQaBQAhQNJJIIhShQACERCAIA0RD7zf5hiIBOZSI5CACuZwcdMRAhnIJNIMKWKPBb8MIFiIJOBILJzhQOYc7YYBY5vVBkiJEJJEIJUHBPMbAARYUI0KKAD" & _
"JKEaDEpAVgAYjHYI8GSACgQb4AcRiGCPJgwNQIEzANIICaUUwpUDIBYjKIzBAsAZiWQ1QYABLZTKBAIATL2CUxXJdV8RABJIpOIiuIRgQUBA="
.DateHeaderField(exHeaderPrevMonth) = "<c><img>up</img>"
.DateHeaderField(exHeaderNextMonth) = "<c><img>down</img>"
.DateHeaderField(exHeaderPrevYear) = "<c><img>left</img>"
.DateHeaderField(exHeaderNextYear) = "<c><img>right</img>"
With .VisualAppearance
.Add 1,"gBFLBCJwBAEHhEJAAEhABFgDg6AADACAxSDEMQBQKAAzQFAYbhgHCGAAGQaBUgmFgAQhFcZQSKUOQTDKMIziYBYfgkMIgSbJUgDGAkRRdDSOYIkWA5AiKEYoThCIxzT" & _
"J8aw3CKbYRAKCXfoUAJFP7Fc6ABJMBx3EyhZ89NDYEwTIKBahoehqIheEQyDSJNb2DCIahhMSEbKtCooDhGFpUWzLdxTJJVawHJoABjkS45PjEAJ+SBPUZVRRlFyfO7B" & _
"KSjMKKXgkG4zABWVa1bC1FzxQ6mKykKQLQADDIDVZAeL3JTNCS5IyLLDtO77EqmZ5la7cUgRDj4AY7Ua+MzubBZaovOqDYzAey7TDWLRXFDNIzzTgQAyHHrETZHGqwJx" & _
"MAEapYGqYpVi2HwzDuQ5oHKIQgggSSUGMOgdE4RhYDwJBVAwIQTH2UYhjQJBRAmZxuCEHZ3icJp5EgKxgAIVgCCQSQSEIBQkCAYhCAIJYKmKNIuFcTBIESPYEk6GBUm+" & _
"BZOmOPgZgWYRTiYEwvEwaIEAAK4KnKOJrgmTpDjCbYJmKSI2CoOxihOLglCuAACioNg8COA4gmcOZOiidg+g+Dh4moOA8CMYokNmCoyiycQ8E8A4iE6D4OjOMgng8ZJj" & _
"iITA8CSEouEcKwKkkLJyhQIoIkYU9LjORhcCsAAIACLQ8iaSJ6FKC5jJoaobA8KYoACCRKnmMJzhuDpZnSboMCKGJ4nMPIPDmYAACwKIDk6CoLCeU40m6I5oliMoKDya" & _
"ICokLIpgoThviOKJoGYf4KmUKhMjMLJLCAAojCyaYoiYGoGmqM46CkOwPEoKonAACxKlSdItmiWBeBeDgrioNo3D0KxSlAAAtgsUpYnUPRPEoco8hCa+T40SxbBRj5tE" & _
"sHJ1i6JhbGYS4ug8awelQLZAAKZI5C4DxrhYQ9ehmUppWiA48nAPRuFKYpiAAC47laZQ9iuKZSgOPotkuFI7C6C4gACPJAm8eQOhOQZoikDp3kCS5AACPoEk8fBGnqQg" & _
"pDOSppD2TxjlyPZD6CfwekQTx5lKP5ImseZTCAL5MAMAAAkoTADmMLpIjISp+HSS4PgyMAADBzAHDSIoPCOUpWjObIKE8NJOHKIwPEaTprBsHpdjWLB9AieQ+DQYwQAA" & _
"MR1EOZxWi+bx7HcWQ8msfRYnnDZQACRwxgwc5rGaMZPE0ZxqjWNZtgyRwAAyTZEnuXJzEyAx2kQcxNkye5cEy3cYAcANrGAIH4OAhx3gNGGPAfgIR8jBA4McBMARVhnH" & _
"4HQOYmxuCpF2MsecEQVBvGQCcIQug6itGQBoARAQ="
End With
.EndUpdate
End With
|
|
133
|
How can I arrange the month's header (right up down, next, prev month, picture, ebn)
With Calendar1
.BeginUpdate
.Appearance = None2
.Background(exDateHeader) = .BackColor
.FirstDay = Monday
.MaxMonthX = 2
.MaxMonthY = 2
.DrawGridLine = Solid
.WeekDays = "Su Mo Tu We Th Fr Sa"
.MarkToday = True
.AutoSize = exFixedSize
.AlignmentDay = CenterAlignment
.FixedCellHeight = 32
.FixedCellWidth = 32
.DateHeaderFormat = "1,(2[b=0][bg=0x01000000]/3[b=0][bg=0x01000000]):32"
.DateHeaderField(exHeaderDate) = " ( ( ( month(value) = month(date(``) ) and ( year(value) = year(date(``) ) ) ) ) ? `<b><fgcolor=0000FF>` : `` ) + `<c><%month%>" & _
" <%year%>`"
.HTMLPicture("up") = "gCJKBOI4NBQaBQAhQNJJIIhShQACERCAIA0RD7zf5hiJZJJEIJUPDaMZkUAQGAOP4DRShOgvHIGQA0U5CbKzOIZYRIICzCaUX4PS4hRgEGg/QaKJLhGSESIIZoMfAMM" & _
"IkKQzJxDDBJaCMaoQSABVhAXgQRBLRFdNhIB4QY4PfyUJB7AYAFo+DIWOb7LDdiIAJJFJxEVxCMCCgIA="
.HTMLPicture("down") = "gCJKBOI4NBQaBQAhQNJJIIhShQACERCAIA0RD7zf5hiIEM5BJpBhSxR4LfhhAsRKZJIhBKg4J7tRjJBIAEAMAjzWIJba0E5rWQcWaBAoFR7oK4HewRZCMPiMUDLXRoS" & _
"4PfjCQJrEhdaJ5ET4YIvTgOJ5kFSTKpkFaTKLEFqTGxyFgTIyuMgCeJaPwDSIKEhlCT5ZoWFT4iIAJJFJxEVxCMCCgIA="
.HTMLPicture("left") = "gCJKBOI4NBQaBQAhQNJJIIhShQACERCAIA0RD7zf5hiJUJJEIJUPDaMZkEANWACeJvMgBIwSGgXAaxGIQI6RMYAJBzFQQHYBeIzKQNYCpTIYAbwNQmMgAILNfAMEBKG" & _
"YuAaIaxMGYDFD2ARVASRNBDNCeSAIDRCW7MAgDDDZDIAKbADgRVrfUCNiIAJJFJxEVxCMCCgI"
.HTMLPicture("right") = "gCJKBOI4NBQaBQAhQNJJIIhShQACERCAIA0RD7zf5hiIBOZSI5CACuZwcdMRAhnIJNIMKWKPBb8MIFiIJOBILJzhQOYc7YYBY5vVBkiJEJJEIJUHBPMbAARYUI0KKAD" & _
"JKEaDEpAVgAYjHYI8GSACgQb4AcRiGCPJgwNQIEzANIICaUUwpUDIBYjKIzBAsAZiWQ1QYABLZTKBAIATL2CUxXJdV8RABJIpOIiuIRgQUBA="
.DateHeaderField(exHeaderPrevMonth) = "<c><img>up</img>"
.DateHeaderField(exHeaderNextMonth) = "<c><img>down</img>"
.DateHeaderField(exHeaderPrevYear) = "<c><img>left</img>"
.DateHeaderField(exHeaderNextYear) = "<c><img>right</img>"
With .VisualAppearance
.Add 1,"gBFLBCJwBAEHhEJAAEhABFgDg6AADACAxSDEMQBQKAAzQFAYbhgHCGAAGQaBUgmFgAQhFcZQSKUOQTDKMIziYBYfgkMIgSbJUgDGAkRRdDSOYIkWA5AiKEYoThCIxzT" & _
"J8aw3CKbYRAKCXfoUAJFP7Fc6ABJMBx3EyhZ89NDYEwTIKBahoehqIheEQyDSJNb2DCIahhMSEbKtCooDhGFpUWzLdxTJJVawHJoABjkS45PjEAJ+SBPUZVRRlFyfO7B" & _
"KSjMKKXgkG4zABWVa1bC1FzxQ6mKykKQLQADDIDVZAeL3JTNCS5IyLLDtO77EqmZ5la7cUgRDj4AY7Ua+MzubBZaovOqDYzAey7TDWLRXFDNIzzTgQAyHHrETZHGqwJx" & _
"MAEapYGqYpVi2HwzDuQ5oHKIQgggSSUGMOgdE4RhYDwJBVAwIQTH2UYhjQJBRAmZxuCEHZ3icJp5EgKxgAIVgCCQSQSEIBQkCAYhCAIJYKmKNIuFcTBIESPYEk6GBUm+" & _
"BZOmOPgZgWYRTiYEwvEwaIEAAK4KnKOJrgmTpDjCbYJmKSI2CoOxihOLglCuAACioNg8COA4gmcOZOiidg+g+Dh4moOA8CMYokNmCoyiycQ8E8A4iE6D4OjOMgng8ZJj" & _
"iITA8CSEouEcKwKkkLJyhQIoIkYU9LjORhcCsAAIACLQ8iaSJ6FKC5jJoaobA8KYoACCRKnmMJzhuDpZnSboMCKGJ4nMPIPDmYAACwKIDk6CoLCeU40m6I5oliMoKDya" & _
"ICokLIpgoThviOKJoGYf4KmUKhMjMLJLCAAojCyaYoiYGoGmqM46CkOwPEoKonAACxKlSdItmiWBeBeDgrioNo3D0KxSlAAAtgsUpYnUPRPEoco8hCa+T40SxbBRj5tE" & _
"sHJ1i6JhbGYS4ug8awelQLZAAKZI5C4DxrhYQ9ehmUppWiA48nAPRuFKYpiAAC47laZQ9iuKZSgOPotkuFI7C6C4gACPJAm8eQOhOQZoikDp3kCS5AACPoEk8fBGnqQg" & _
"pDOSppD2TxjlyPZD6CfwekQTx5lKP5ImseZTCAL5MAMAAAkoTADmMLpIjISp+HSS4PgyMAADBzAHDSIoPCOUpWjObIKE8NJOHKIwPEaTprBsHpdjWLB9AieQ+DQYwQAA" & _
"MR1EOZxWi+bx7HcWQ8msfRYnnDZQACRwxgwc5rGaMZPE0ZxqjWNZtgyRwAAyTZEnuXJzEyAx2kQcxNkye5cEy3cYAcANrGAIH4OAhx3gNGGPAfgIR8jBA4McBMARVhnH" & _
"4HQOYmxuCpF2MsecEQVBvGQCcIQug6itGQBoARAQ="
End With
.EndUpdate
End With
|
|
132
|
How can I arrange the month's header (left, next, prev month, picture, ebn)
With Calendar1
.BeginUpdate
.Appearance = None2
.Background(exDateHeader) = .BackColor
.FirstDay = Monday
.MaxMonthX = 2
.MaxMonthY = 2
.DrawGridLine = Solid
.WeekDays = "Su Mo Tu We Th Fr Sa"
.MarkToday = True
.AutoSize = exFixedSize
.AlignmentDay = CenterAlignment
.FixedCellHeight = 32
.FixedCellWidth = 32
.DateHeaderFormat = "(""""[b=0],(""""[b=0]/24;2[b=0][bg=0x01000000]/""""[b=0]):24,""""[b=0]):32,(""""[b=0],(""""[b=0]/24;3[b=0][bg=0x01000000]/""""[" & _
"b=0]):24,""""[b=0]):32,1"
.DateHeaderField(exHeaderDate) = " ( ( ( month(value) = month(date(``) ) and ( year(value) = year(date(``) ) ) ) ) ? `<b><fgcolor=0000FF>` : `` ) + `<c><%month%>" & _
" <%year%>`"
.HTMLPicture("up") = "gCJKBOI4NBQaBQAhQNJJIIhShQACERCAIA0RD7zf5hiJZJJEIJUPDaMZkUAQGAOP4DRShOgvHIGQA0U5CbKzOIZYRIICzCaUX4PS4hRgEGg/QaKJLhGSESIIZoMfAMM" & _
"IkKQzJxDDBJaCMaoQSABVhAXgQRBLRFdNhIB4QY4PfyUJB7AYAFo+DIWOb7LDdiIAJJFJxEVxCMCCgIA="
.HTMLPicture("down") = "gCJKBOI4NBQaBQAhQNJJIIhShQACERCAIA0RD7zf5hiIEM5BJpBhSxR4LfhhAsRKZJIhBKg4J7tRjJBIAEAMAjzWIJba0E5rWQcWaBAoFR7oK4HewRZCMPiMUDLXRoS" & _
"4PfjCQJrEhdaJ5ET4YIvTgOJ5kFSTKpkFaTKLEFqTGxyFgTIyuMgCeJaPwDSIKEhlCT5ZoWFT4iIAJJFJxEVxCMCCgIA="
.HTMLPicture("left") = "gCJKBOI4NBQaBQAhQNJJIIhShQACERCAIA0RD7zf5hiJUJJEIJUPDaMZkEANWACeJvMgBIwSGgXAaxGIQI6RMYAJBzFQQHYBeIzKQNYCpTIYAbwNQmMgAILNfAMEBKG" & _
"YuAaIaxMGYDFD2ARVASRNBDNCeSAIDRCW7MAgDDDZDIAKbADgRVrfUCNiIAJJFJxEVxCMCCgI"
.HTMLPicture("right") = "gCJKBOI4NBQaBQAhQNJJIIhShQACERCAIA0RD7zf5hiIBOZSI5CACuZwcdMRAhnIJNIMKWKPBb8MIFiIJOBILJzhQOYc7YYBY5vVBkiJEJJEIJUHBPMbAARYUI0KKAD" & _
"JKEaDEpAVgAYjHYI8GSACgQb4AcRiGCPJgwNQIEzANIICaUUwpUDIBYjKIzBAsAZiWQ1QYABLZTKBAIATL2CUxXJdV8RABJIpOIiuIRgQUBA="
.DateHeaderField(exHeaderPrevMonth) = "<c><img>up</img>"
.DateHeaderField(exHeaderNextMonth) = "<c><img>down</img>"
.DateHeaderField(exHeaderPrevYear) = "<c><img>left</img>"
.DateHeaderField(exHeaderNextYear) = "<c><img>right</img>"
With .VisualAppearance
.Add 1,"gBFLBCJwBAEHhEJAAEhABFgDg6AADACAxSDEMQBQKAAzQFAYbhgHCGAAGQaBUgmFgAQhFcZQSKUOQTDKMIziYBYfgkMIgSbJUgDGAkRRdDSOYIkWA5AiKEYoThCIxzT" & _
"J8aw3CKbYRAKCXfoUAJFP7Fc6ABJMBx3EyhZ89NDYEwTIKBahoehqIheEQyDSJNb2DCIahhMSEbKtCooDhGFpUWzLdxTJJVawHJoABjkS45PjEAJ+SBPUZVRRlFyfO7B" & _
"KSjMKKXgkG4zABWVa1bC1FzxQ6mKykKQLQADDIDVZAeL3JTNCS5IyLLDtO77EqmZ5la7cUgRDj4AY7Ua+MzubBZaovOqDYzAey7TDWLRXFDNIzzTgQAyHHrETZHGqwJx" & _
"MAEapYGqYpVi2HwzDuQ5oHKIQgggSSUGMOgdE4RhYDwJBVAwIQTH2UYhjQJBRAmZxuCEHZ3icJp5EgKxgAIVgCCQSQSEIBQkCAYhCAIJYKmKNIuFcTBIESPYEk6GBUm+" & _
"BZOmOPgZgWYRTiYEwvEwaIEAAK4KnKOJrgmTpDjCbYJmKSI2CoOxihOLglCuAACioNg8COA4gmcOZOiidg+g+Dh4moOA8CMYokNmCoyiycQ8E8A4iE6D4OjOMgng8ZJj" & _
"iITA8CSEouEcKwKkkLJyhQIoIkYU9LjORhcCsAAIACLQ8iaSJ6FKC5jJoaobA8KYoACCRKnmMJzhuDpZnSboMCKGJ4nMPIPDmYAACwKIDk6CoLCeU40m6I5oliMoKDya" & _
"ICokLIpgoThviOKJoGYf4KmUKhMjMLJLCAAojCyaYoiYGoGmqM46CkOwPEoKonAACxKlSdItmiWBeBeDgrioNo3D0KxSlAAAtgsUpYnUPRPEoco8hCa+T40SxbBRj5tE" & _
"sHJ1i6JhbGYS4ug8awelQLZAAKZI5C4DxrhYQ9ehmUppWiA48nAPRuFKYpiAAC47laZQ9iuKZSgOPotkuFI7C6C4gACPJAm8eQOhOQZoikDp3kCS5AACPoEk8fBGnqQg" & _
"pDOSppD2TxjlyPZD6CfwekQTx5lKP5ImseZTCAL5MAMAAAkoTADmMLpIjISp+HSS4PgyMAADBzAHDSIoPCOUpWjObIKE8NJOHKIwPEaTprBsHpdjWLB9AieQ+DQYwQAA" & _
"MR1EOZxWi+bx7HcWQ8msfRYnnDZQACRwxgwc5rGaMZPE0ZxqjWNZtgyRwAAyTZEnuXJzEyAx2kQcxNkye5cEy3cYAcANrGAIH4OAhx3gNGGPAfgIR8jBA4McBMARVhnH" & _
"4HQOYmxuCpF2MsecEQVBvGQCcIQug6itGQBoARAQ="
End With
.EndUpdate
End With
|
|
131
|
How can I arrange the month's header (left, right, next, prev month, picture, ebn)
With Calendar1
.BeginUpdate
.Appearance = None2
.Background(exDateHeader) = .BackColor
.FirstDay = Monday
.MaxMonthX = 2
.MaxMonthY = 2
.DrawGridLine = Solid
.WeekDays = "Su Mo Tu We Th Fr Sa"
.MarkToday = True
.AutoSize = exFixedSize
.AlignmentDay = CenterAlignment
.FixedCellHeight = 32
.FixedCellWidth = 32
.DateHeaderFormat = "(""""[b=0],(""""[b=0]/24;2[b=0][bg=0x01000000]/""""[b=0]):24,""""[b=0]):32,1,(""""[b=0],(""""[b=0]/24;3[b=0][bg=0x01000000]/"""" & _
""[b=0]):24,""""[b=0]):32"
.DateHeaderField(exHeaderDate) = " ( ( ( month(value) = month(date(``) ) and ( year(value) = year(date(``) ) ) ) ) ? `<b><fgcolor=0000FF>` : `` ) + `<c><%month%>" & _
" <%year%>`"
.HTMLPicture("up") = "gCJKBOI4NBQaBQAhQNJJIIhShQACERCAIA0RD7zf5hiJZJJEIJUPDaMZkUAQGAOP4DRShOgvHIGQA0U5CbKzOIZYRIICzCaUX4PS4hRgEGg/QaKJLhGSESIIZoMfAMM" & _
"IkKQzJxDDBJaCMaoQSABVhAXgQRBLRFdNhIB4QY4PfyUJB7AYAFo+DIWOb7LDdiIAJJFJxEVxCMCCgIA="
.HTMLPicture("down") = "gCJKBOI4NBQaBQAhQNJJIIhShQACERCAIA0RD7zf5hiIEM5BJpBhSxR4LfhhAsRKZJIhBKg4J7tRjJBIAEAMAjzWIJba0E5rWQcWaBAoFR7oK4HewRZCMPiMUDLXRoS" & _
"4PfjCQJrEhdaJ5ET4YIvTgOJ5kFSTKpkFaTKLEFqTGxyFgTIyuMgCeJaPwDSIKEhlCT5ZoWFT4iIAJJFJxEVxCMCCgIA="
.HTMLPicture("left") = "gCJKBOI4NBQaBQAhQNJJIIhShQACERCAIA0RD7zf5hiJUJJEIJUPDaMZkEANWACeJvMgBIwSGgXAaxGIQI6RMYAJBzFQQHYBeIzKQNYCpTIYAbwNQmMgAILNfAMEBKG" & _
"YuAaIaxMGYDFD2ARVASRNBDNCeSAIDRCW7MAgDDDZDIAKbADgRVrfUCNiIAJJFJxEVxCMCCgI"
.HTMLPicture("right") = "gCJKBOI4NBQaBQAhQNJJIIhShQACERCAIA0RD7zf5hiIBOZSI5CACuZwcdMRAhnIJNIMKWKPBb8MIFiIJOBILJzhQOYc7YYBY5vVBkiJEJJEIJUHBPMbAARYUI0KKAD" & _
"JKEaDEpAVgAYjHYI8GSACgQb4AcRiGCPJgwNQIEzANIICaUUwpUDIBYjKIzBAsAZiWQ1QYABLZTKBAIATL2CUxXJdV8RABJIpOIiuIRgQUBA="
.DateHeaderField(exHeaderPrevMonth) = "<c><img>up</img>"
.DateHeaderField(exHeaderNextMonth) = "<c><img>down</img>"
.DateHeaderField(exHeaderPrevYear) = "<c><img>left</img>"
.DateHeaderField(exHeaderNextYear) = "<c><img>right</img>"
With .VisualAppearance
.Add 1,"gBFLBCJwBAEHhEJAAEhABFgDg6AADACAxSDEMQBQKAAzQFAYbhgHCGAAGQaBUgmFgAQhFcZQSKUOQTDKMIziYBYfgkMIgSbJUgDGAkRRdDSOYIkWA5AiKEYoThCIxzT" & _
"J8aw3CKbYRAKCXfoUAJFP7Fc6ABJMBx3EyhZ89NDYEwTIKBahoehqIheEQyDSJNb2DCIahhMSEbKtCooDhGFpUWzLdxTJJVawHJoABjkS45PjEAJ+SBPUZVRRlFyfO7B" & _
"KSjMKKXgkG4zABWVa1bC1FzxQ6mKykKQLQADDIDVZAeL3JTNCS5IyLLDtO77EqmZ5la7cUgRDj4AY7Ua+MzubBZaovOqDYzAey7TDWLRXFDNIzzTgQAyHHrETZHGqwJx" & _
"MAEapYGqYpVi2HwzDuQ5oHKIQgggSSUGMOgdE4RhYDwJBVAwIQTH2UYhjQJBRAmZxuCEHZ3icJp5EgKxgAIVgCCQSQSEIBQkCAYhCAIJYKmKNIuFcTBIESPYEk6GBUm+" & _
"BZOmOPgZgWYRTiYEwvEwaIEAAK4KnKOJrgmTpDjCbYJmKSI2CoOxihOLglCuAACioNg8COA4gmcOZOiidg+g+Dh4moOA8CMYokNmCoyiycQ8E8A4iE6D4OjOMgng8ZJj" & _
"iITA8CSEouEcKwKkkLJyhQIoIkYU9LjORhcCsAAIACLQ8iaSJ6FKC5jJoaobA8KYoACCRKnmMJzhuDpZnSboMCKGJ4nMPIPDmYAACwKIDk6CoLCeU40m6I5oliMoKDya" & _
"ICokLIpgoThviOKJoGYf4KmUKhMjMLJLCAAojCyaYoiYGoGmqM46CkOwPEoKonAACxKlSdItmiWBeBeDgrioNo3D0KxSlAAAtgsUpYnUPRPEoco8hCa+T40SxbBRj5tE" & _
"sHJ1i6JhbGYS4ug8awelQLZAAKZI5C4DxrhYQ9ehmUppWiA48nAPRuFKYpiAAC47laZQ9iuKZSgOPotkuFI7C6C4gACPJAm8eQOhOQZoikDp3kCS5AACPoEk8fBGnqQg" & _
"pDOSppD2TxjlyPZD6CfwekQTx5lKP5ImseZTCAL5MAMAAAkoTADmMLpIjISp+HSS4PgyMAADBzAHDSIoPCOUpWjObIKE8NJOHKIwPEaTprBsHpdjWLB9AieQ+DQYwQAA" & _
"MR1EOZxWi+bx7HcWQ8msfRYnnDZQACRwxgwc5rGaMZPE0ZxqjWNZtgyRwAAyTZEnuXJzEyAx2kQcxNkye5cEy3cYAcANrGAIH4OAhx3gNGGPAfgIR8jBA4McBMARVhnH" & _
"4HQOYmxuCpF2MsecEQVBvGQCcIQug6itGQBoARAQ="
End With
.EndUpdate
End With
|
|
130
|
How can I arrange the month's header (right, next, prev month, picture, ebn)
With Calendar1
.BeginUpdate
.Appearance = None2
.Background(exDateHeader) = .BackColor
.FirstDay = Monday
.MaxMonthX = 2
.MaxMonthY = 2
.DrawGridLine = Solid
.WeekDays = "Su Mo Tu We Th Fr Sa"
.MarkToday = True
.AutoSize = exFixedSize
.AlignmentDay = CenterAlignment
.FixedCellHeight = 32
.FixedCellWidth = 32
.DateHeaderFormat = "1,(""""[b=0],(""""[b=0]/24;2[b=0][bg=0x01000000]/""""[b=0]):24,""""[b=0]):32,(""""[b=0],(""""[b=0]/24;3[b=0][bg=0x01000000]/"""" & _
""[b=0]):24,""""[b=0]):32"
.DateHeaderField(exHeaderDate) = " ( ( ( month(value) = month(date(``) ) and ( year(value) = year(date(``) ) ) ) ) ? `<b><fgcolor=0000FF>` : `` ) + `<c><%month%>" & _
" <%year%>`"
.HTMLPicture("up") = "gCJKBOI4NBQaBQAhQNJJIIhShQACERCAIA0RD7zf5hiJZJJEIJUPDaMZkUAQGAOP4DRShOgvHIGQA0U5CbKzOIZYRIICzCaUX4PS4hRgEGg/QaKJLhGSESIIZoMfAMM" & _
"IkKQzJxDDBJaCMaoQSABVhAXgQRBLRFdNhIB4QY4PfyUJB7AYAFo+DIWOb7LDdiIAJJFJxEVxCMCCgIA="
.HTMLPicture("down") = "gCJKBOI4NBQaBQAhQNJJIIhShQACERCAIA0RD7zf5hiIEM5BJpBhSxR4LfhhAsRKZJIhBKg4J7tRjJBIAEAMAjzWIJba0E5rWQcWaBAoFR7oK4HewRZCMPiMUDLXRoS" & _
"4PfjCQJrEhdaJ5ET4YIvTgOJ5kFSTKpkFaTKLEFqTGxyFgTIyuMgCeJaPwDSIKEhlCT5ZoWFT4iIAJJFJxEVxCMCCgIA="
.HTMLPicture("left") = "gCJKBOI4NBQaBQAhQNJJIIhShQACERCAIA0RD7zf5hiJUJJEIJUPDaMZkEANWACeJvMgBIwSGgXAaxGIQI6RMYAJBzFQQHYBeIzKQNYCpTIYAbwNQmMgAILNfAMEBKG" & _
"YuAaIaxMGYDFD2ARVASRNBDNCeSAIDRCW7MAgDDDZDIAKbADgRVrfUCNiIAJJFJxEVxCMCCgI"
.HTMLPicture("right") = "gCJKBOI4NBQaBQAhQNJJIIhShQACERCAIA0RD7zf5hiIBOZSI5CACuZwcdMRAhnIJNIMKWKPBb8MIFiIJOBILJzhQOYc7YYBY5vVBkiJEJJEIJUHBPMbAARYUI0KKAD" & _
"JKEaDEpAVgAYjHYI8GSACgQb4AcRiGCPJgwNQIEzANIICaUUwpUDIBYjKIzBAsAZiWQ1QYABLZTKBAIATL2CUxXJdV8RABJIpOIiuIRgQUBA="
.DateHeaderField(exHeaderPrevMonth) = "<c><img>up</img>"
.DateHeaderField(exHeaderNextMonth) = "<c><img>down</img>"
.DateHeaderField(exHeaderPrevYear) = "<c><img>left</img>"
.DateHeaderField(exHeaderNextYear) = "<c><img>right</img>"
With .VisualAppearance
.Add 1,"gBFLBCJwBAEHhEJAAEhABFgDg6AADACAxSDEMQBQKAAzQFAYbhgHCGAAGQaBUgmFgAQhFcZQSKUOQTDKMIziYBYfgkMIgSbJUgDGAkRRdDSOYIkWA5AiKEYoThCIxzT" & _
"J8aw3CKbYRAKCXfoUAJFP7Fc6ABJMBx3EyhZ89NDYEwTIKBahoehqIheEQyDSJNb2DCIahhMSEbKtCooDhGFpUWzLdxTJJVawHJoABjkS45PjEAJ+SBPUZVRRlFyfO7B" & _
"KSjMKKXgkG4zABWVa1bC1FzxQ6mKykKQLQADDIDVZAeL3JTNCS5IyLLDtO77EqmZ5la7cUgRDj4AY7Ua+MzubBZaovOqDYzAey7TDWLRXFDNIzzTgQAyHHrETZHGqwJx" & _
"MAEapYGqYpVi2HwzDuQ5oHKIQgggSSUGMOgdE4RhYDwJBVAwIQTH2UYhjQJBRAmZxuCEHZ3icJp5EgKxgAIVgCCQSQSEIBQkCAYhCAIJYKmKNIuFcTBIESPYEk6GBUm+" & _
"BZOmOPgZgWYRTiYEwvEwaIEAAK4KnKOJrgmTpDjCbYJmKSI2CoOxihOLglCuAACioNg8COA4gmcOZOiidg+g+Dh4moOA8CMYokNmCoyiycQ8E8A4iE6D4OjOMgng8ZJj" & _
"iITA8CSEouEcKwKkkLJyhQIoIkYU9LjORhcCsAAIACLQ8iaSJ6FKC5jJoaobA8KYoACCRKnmMJzhuDpZnSboMCKGJ4nMPIPDmYAACwKIDk6CoLCeU40m6I5oliMoKDya" & _
"ICokLIpgoThviOKJoGYf4KmUKhMjMLJLCAAojCyaYoiYGoGmqM46CkOwPEoKonAACxKlSdItmiWBeBeDgrioNo3D0KxSlAAAtgsUpYnUPRPEoco8hCa+T40SxbBRj5tE" & _
"sHJ1i6JhbGYS4ug8awelQLZAAKZI5C4DxrhYQ9ehmUppWiA48nAPRuFKYpiAAC47laZQ9iuKZSgOPotkuFI7C6C4gACPJAm8eQOhOQZoikDp3kCS5AACPoEk8fBGnqQg" & _
"pDOSppD2TxjlyPZD6CfwekQTx5lKP5ImseZTCAL5MAMAAAkoTADmMLpIjISp+HSS4PgyMAADBzAHDSIoPCOUpWjObIKE8NJOHKIwPEaTprBsHpdjWLB9AieQ+DQYwQAA" & _
"MR1EOZxWi+bx7HcWQ8msfRYnnDZQACRwxgwc5rGaMZPE0ZxqjWNZtgyRwAAyTZEnuXJzEyAx2kQcxNkye5cEy3cYAcANrGAIH4OAhx3gNGGPAfgIR8jBA4McBMARVhnH" & _
"4HQOYmxuCpF2MsecEQVBvGQCcIQug6itGQBoARAQ="
End With
.EndUpdate
End With
|
|
129
|
Can I specify a different foreground color for the current month
With Calendar1
.BeginUpdate
.Appearance = None2
.Background(exDateHeader) = .BackColor
.FirstDay = Monday
.MaxMonthX = 2
.MaxMonthY = 2
.DrawGridLine = Solid
.WeekDays = "Su Mo Tu We Th Fr Sa"
.MarkToday = True
.AutoSize = exFixedSize
.AlignmentDay = CenterAlignment
.FixedCellHeight = 32
.FixedCellWidth = 32
.DateHeaderFormat = "1,2:32,3:32"
.DateHeaderField(exHeaderDate) = " ( ( ( month(value) = month(date(``) ) and ( year(value) = year(date(``) ) ) ) ) ? `<b><fgcolor=0000FF>` : `` ) + `<c><%month%>" & _
" <%year%>`"
.EndUpdate
End With
|
|
128
|
How do I change the +/- when using the custom format for month's header (with no background)
With Calendar1
.BeginUpdate
.Appearance = None2
.Background(exDateHeader) = .BackColor
.FirstDay = Monday
.MaxMonthX = 2
.MaxMonthY = 2
.DrawGridLine = Solid
.WeekDays = "Su Mo Tu We Th Fr Sa"
.MarkToday = True
.AutoSize = exFixedSize
.AlignmentDay = CenterAlignment
.FixedCellHeight = 32
.FixedCellWidth = 32
.DateHeaderFormat = "1,2:32,3:32"
.HTMLPicture("up") = "gCJKBOI4NBQaBQAhQNJJIIhShQACERCAIA0RD7zf5hiJZJJEIJUPDaMZkUAQGAOP4DRShOgvHIGQA0U5CbKzOIZYRIICzCaUX4PS4hRgEGg/QaKJLhGSESIIZoMfAMM" & _
"IkKQzJxDDBJaCMaoQSABVhAXgQRBLRFdNhIB4QY4PfyUJB7AYAFo+DIWOb7LDdiIAJJFJxEVxCMCCgIA="
.HTMLPicture("down") = "gCJKBOI4NBQaBQAhQNJJIIhShQACERCAIA0RD7zf5hiIEM5BJpBhSxR4LfhhAsRKZJIhBKg4J7tRjJBIAEAMAjzWIJba0E5rWQcWaBAoFR7oK4HewRZCMPiMUDLXRoS" & _
"4PfjCQJrEhdaJ5ET4YIvTgOJ5kFSTKpkFaTKLEFqTGxyFgTIyuMgCeJaPwDSIKEhlCT5ZoWFT4iIAJJFJxEVxCMCCgIA="
.DateHeaderField(exHeaderPrevMonth) = "<c><img>up</img>"
.DateHeaderField(exHeaderNextMonth) = "<c><img>down</img>"
.EndUpdate
End With
|
|
127
|
How do I change the +/- when using the custom format for month's header (with background)
With Calendar1
.BeginUpdate
.Appearance = None2
.Background(exDateHeader) = .BackColor
.FirstDay = Monday
.MaxMonthX = 2
.MaxMonthY = 2
.DrawGridLine = Solid
.WeekDays = "Su Mo Tu We Th Fr Sa"
.MarkToday = True
.AutoSize = exFixedSize
.AlignmentDay = CenterAlignment
.FixedCellHeight = 32
.FixedCellWidth = 32
.DateHeaderFormat = "1,(""""[b=0],(""""[b=0]/24;2[b=0][bg=RGB(196,196,196)]/""""[b=0]):24,""""[b=0]):32,(""""[b=0],(""""[b=0]/24;3[b=0][bg=RGB(196,1" & _
"96,196)]/""""[b=0]):24,""""[b=0]):32"
.HTMLPicture("up") = "gCJKBOI4NBQaBQAhQNJJIIhShQACERCAIA0RD7zf5hiJZJJEIJUPDaMZkUAQGAOP4DRShOgvHIGQA0U5CbKzOIZYRIICzCaUX4PS4hRgEGg/QaKJLhGSESIIZoMfAMM" & _
"IkKQzJxDDBJaCMaoQSABVhAXgQRBLRFdNhIB4QY4PfyUJB7AYAFo+DIWOb7LDdiIAJJFJxEVxCMCCgIA="
.HTMLPicture("down") = "gCJKBOI4NBQaBQAhQNJJIIhShQACERCAIA0RD7zf5hiIEM5BJpBhSxR4LfhhAsRKZJIhBKg4J7tRjJBIAEAMAjzWIJba0E5rWQcWaBAoFR7oK4HewRZCMPiMUDLXRoS" & _
"4PfjCQJrEhdaJ5ET4YIvTgOJ5kFSTKpkFaTKLEFqTGxyFgTIyuMgCeJaPwDSIKEhlCT5ZoWFT4iIAJJFJxEVxCMCCgIA="
.DateHeaderField(exHeaderPrevMonth) = "<c><img>up</img>"
.DateHeaderField(exHeaderNextMonth) = "<c><img>down</img>"
.EndUpdate
End With
|
|
126
|
How can I arrange the month's header (right, next, prev month)
With Calendar1
.BeginUpdate
.Appearance = None2
.Background(exDateHeader) = .BackColor
.FirstDay = Monday
.MaxMonthX = 2
.MaxMonthY = 2
.DrawGridLine = Solid
.WeekDays = "Su Mo Tu We Th Fr Sa"
.MarkToday = True
.AutoSize = exFixedSize
.AlignmentDay = CenterAlignment
.FixedCellHeight = 32
.FixedCellWidth = 32
.DateHeaderFormat = "1,(""""[b=0],(""""[b=0]/24;2[b=0][bg=RGB(196,196,196)]/""""[b=0]):24,""""[b=0]):32,(""""[b=0],(""""[b=0]/24;3[b=0][bg=RGB(196,1" & _
"96,196)]/""""[b=0]):24,""""[b=0]):32"
.EndUpdate
End With
|
|
125
|
How do I display the week number according, so the January 1st is in the first week
With Calendar1
.BeginUpdate
.FirstDay = Sunday
.DisplayWeekNumberAs = exSimpleWeekNumber
.ShowWeeks = True
.Date = #1/1/2016#
.EndUpdate
End With
|
|
124
|
How do I display the week number according to ISO8601 standard
With Calendar1
.BeginUpdate
.FirstDay = Monday
.DisplayWeekNumberAs = exISO8601WeekNumber
.ShowWeeks = True
.Date = #1/1/2016#
.EndUpdate
End With
|
|
123
|
Just seen the BackgroundExt property. Not sure what I can do with that
With Calendar1
.BeginUpdate
.VisualAppearance.Add 1,"c:\exontrol\images\normal.ebn"
.AlignmentDay = CenterAlignment
.FixedCellWidth = 48
.FixedCellHeight = 48
.AutoSize = exFixedSize
.MaxMonthX = 1
.MaxMonthY = 1
.Date = #2/1/2014#
.ShowNonMonthDays = False
.DrawGridLine = LargeDots
With .Events
.Add(#2/3/2014#).BackgroundExt = "bottom[8,pattern=0x006,patterncolor=RGB(190,190,190),frame=RGB(0,0,0),framethick]"
.Add(#2/4/2014#).BackgroundExt = "bottom[100%,pattern=0x003,frame=RGB(0,0,0),framethick]"
.Add(#2/5/2014#).BackgroundExt = "top[8,pattern=0x006,patterncolor=RGB(190,190,190),frame=RGB(0,0,0),framethick]"
.Add(#2/10/2014#).BackgroundExt = "top[4](left[4],right[4],client),bottom[4](left[4],right[4],client),left[4],right[4],client(left[10%](top[90%,back=RGB(0,0,0)])," & _
"top[30%,back=RGB(254,217,102)],client[back=RGB(123,250,212)])"
.Add(#2/11/2014#).BackgroundExt = "left[33%,back=RGB(0,128,0)],left[33%,back=RGB(0,255,0)],client[back=RGB(255,128,128)]"
.Add(#2/12/2014#).BackgroundExt = "top[33%,back=RGB(0,128,0)],left[33%,back=RGB(0,255,0)],client[back=RGB(255,128,128)](top[50%,back=RGB(0,255,255)])"
.Add(#2/13/2014#).BackgroundExt = "bottom[12](left[75%,back=0x01000000]),none[(0,100%-22,100%,22),text=`<sha ;;0><font ;6>75%`,align=0x11]"
.Add(#2/14/2014#).BackgroundExt = "top[12](left[55%,back=0x01FEFEFE]),none[(0,0,100%,12),pattern=0x000,frame=RGB(0,255,0)],none[(0,0,100%,22),text=`<sha ;;0><font" & _
" ;6>55%`,align=0x11]"
.Add(#2/17/2014#).BackgroundExt = "bottom[16,align=0x11,text=`<fgcolor 808080><font ;6>extra`]"
.Add(#2/18/2014#).BackgroundExt = "root[text=`<fgcolor 808080><font ;6>extra 2`,align=0x01](bottom[16,text=`<fgcolor 808080><font ;6>extra1`,align=0x21])"
With .Add(#2/19/2014#)
.BackgroundExt = "top[4](left[4],right[4],client),bottom[4](left[4],right[4],client),left[4],right[4],client[text=`<fgcolor 808080><font ;6><b>B`" & _
",align=0x22](client[text=`<fgcolor 808080><font ;6><b>A`,align=0x20](client[text=`<fgcolor 808080><font ;6><b>D`,align=0x00](cli" & _
"ent[text=`<fgcolor 808080><font ;6><b>C`,align=0x02](client))))"
.Caption = "<sha ;;0><font ;12><fgcolor FF0000><b><%day%>"
End With
.Add(#2/20/2014#).BackgroundExt = "root[text=`<fgcolor 808080><b>B`,align=0x22](client[text=`<fgcolor 808080><b>A`,align=0x20])"
With .Add(#2/21/2014#)
.BackgroundExt = "root[align=0,wordwrap,text=`<font ;6>This is a long story to put on your date, to break the lines. `]"
.Caption = "<b><fgcolor FFFFFF><out 1;2><font ;18><%day%>"
End With
End With
.EndUpdate
End With
|
|
122
|
How can I show a pattern over a date
With Calendar1
.AlignmentDay = CenterAlignment
.FixedCellWidth = 36
.FixedCellHeight = 36
.AutoSize = exFixedSize
.MaxMonthX = 1
.MaxMonthY = 1
.Date = #2/1/2014#
.ShowNonMonthDays = False
.Events.Add(#2/3/2014#).BackgroundExt = "bottom[8,pattern=0x006,patterncolor=RGB(190,190,190),frame=RGB(0,0,0),framethick]"
.Events.Add(#2/4/2014#).BackgroundExt = "bottom[100%,pattern=0x006,patterncolor=RGB(190,190,190),frame=RGB(0,0,0),framethick]"
.Events.Add(#2/5/2014#).BackgroundExt = "top[8,pattern=0x006,patterncolor=RGB(190,190,190),frame=RGB(0,0,0),framethick]"
.DrawGridLine = LargeDots
End With
|
|
121
|
Can I use PNG picture files
With Calendar1
.HTMLPicture("pic1") = "c:\exontrol\images\card.png"
.AlignmentDay = LeftAlignment
.FixedCellWidth = 64
.FixedCellHeight = 48
.AutoSize = exFixedSize
.MaxMonthX = 1
.MaxMonthY = 1
.Events.Add(Calendar1.Date).Caption = "<sha><b><%day%></b></sha> <r><img>pic1</img>"
End With
|
|
120
|
Is it possible to display a custom-size picture assigned to a date
With Calendar1
.HTMLPicture("pic1") = "c:\exontrol\images\zipdisk.gif"
.AlignmentDay = LeftAlignment
.FixedCellWidth = 64
.FixedCellHeight = 48
.AutoSize = exFixedSize
.MaxMonthX = 1
.MaxMonthY = 1
.Events.Add(Calendar1.Date).Caption = "<sha><b><%day%></b></sha> <r><img>pic1</img>"
End With
|
|
119
|
How can I assign a caption and an icon to a date
With Calendar1
.Images "gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTq" & _
"lVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m" & _
"0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/y" & _
"NAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA="
.AlignmentDay = LeftAlignment
.FixedCellWidth = 48
.AutoSize = exFixedSize
.MaxMonthX = 1
.MaxMonthY = 1
.Events.Add(Calendar1.Date).Caption = "<sha><b><%day%></b></sha> <r><img>1</img><off -4><sha;;0><fgcolor FF0000><font ;6>ev</sha>"
End With
|
|
118
|
How can I assign a caption to a date
With Calendar1
.AlignmentDay = LeftAlignment
.FixedCellWidth = 36
.AutoSize = exFixedSize
.MaxMonthX = 1
.MaxMonthY = 1
With .Events.Add(Calendar1.Date)
.Caption = "<sha><b><%day%></b><r><off -4><sha;;0><fgcolor FF0000><font ;6>ev</sha></sha> 1"
.Marker = True
End With
End With
|
|
117
|
How do I align the day in the calendar control
With Calendar1
.AlignmentDay = CenterAlignment
End With
|
|
116
|
How do I specify a different foreground color for weekday headers (S M T W T F S)
With Calendar1
.Background(exDaysHeader) = RGB(255,255,255)
.Background(exDaysHeaderForeColor) = RGB(255,0,0)
End With
|
|
115
|
How does localization work
With Calendar1
.FirstDay = .LocFirstDay
.MonthNames = .LocMonthNames()
.WeekDays = .LocWeekDays()
End With
|
|
114
|
How can I change the control's Visual appearance
With Calendar1
.VisualDesign = "gBFLBWIgBAEHhEJAEGg6EhCDC0HA0IdT/iyAjAAdcWf8YQAAAcKkEThQCCsiAMRhQBkMHhgABEIBsILBQHRCOp0OhvNwgGM+AUImMHmcHms3nM7ns/GUtmEIB0IIc2G" & _
"QgFo0q1VrAygI"
End With
|
|
113
|
How can I align the picture on the control's background
With Calendar1
.Picture = Calendar1.ExecuteTemplate("loadpicture(`c:\exontrol\images\card.png`)")
.PictureDisplay = UpperRight
End With
|
|
112
|
Is it possible to place a picture on the control's background
With Calendar1
.Picture = Calendar1.ExecuteTemplate("loadpicture(`c:\exontrol\images\card.png`)")
End With
|
|
111
|
Is it possible to specify the color or the visual appearance (EBN) for selected dates when the control has no focus
With Calendar1
.VisualAppearance.Add 1,"c:\exontrol\images\normal.ebn"
.Background(exSelBackColorUnFocus) = &H1000000
.Background(exSelForeColorUnFocus) = RGB(0,0,0)
.HideSelection = False
End With
|
|
110
|
Is it possible to specify the color for selected dates when the control loses the focus
With Calendar1
.Background(exSelBackColorUnFocus) = RGB(128,128,128)
.Background(exSelForeColorUnFocus) = RGB(0,0,0)
.HideSelection = False
End With
|
|
109
|
Can I change the visual appearance for the tooltip, using your EBN files
With Calendar1
.ToolTipDelay = 1
.ToolTipWidth = 364
.VisualAppearance.Add 1,"c:\exontrol\images\normal.ebn"
.Background(exToolTipAppearance) = &H1aa80f0
.Events.Add(Calendar1.Date).Comment = "This is a text that shows up when the cursor hovers the date"
.HideSelection = True
End With
|
|
108
|
Can I change the color of the control's border (EBN files)
With Calendar1
.VisualAppearance.Add 1,"c:\exontrol\images\normal.ebn"
.Appearance = &H1aabbc8 Or AppearanceEnum.Etched
End With
|
|
107
|
Is it possible to change the color for days that are not in the month
With Calendar1
.FirstDay = Monday
.ShowNonMonthDays = True
.NonMonthDaysColor = RGB(255,0,0)
End With
|
|
106
|
How can I change the foreground color for non-working days
With Calendar1
.FirstDay = Monday
.NonworkingDaysForeColor = RGB(255,0,0)
End With
|
|
105
|
How do I change the appearance for the months
With Calendar1
.Background(exDateHeader) = RGB(0,0,128)
.Background(exDateHeaderForeColor) = RGB(255,255,255)
End With
|
|
104
|
How can I show the more months with its full size
With Calendar1
.AutoSize = exFitClient
.MaxMonthX = 2
.MaxMonthY = 2
End With
|
|
103
|
How can I show the calendar with its full size
With Calendar1
.AutoSize = exFitClient
.MaxMonthX = 1
.MaxMonthY = 1
End With
|
|
102
|
How can I hide the separator above the Today button
With Calendar1
.Background(exDateSeparatorBar) = .BackColor
End With
|
|
101
|
How do I limit the dates being displayed or selected
With Calendar1
.MaxMonthX = 1
.MaxMonthY = 1
.ShowYearScroll = False
.MinDate = #1/1/2001#
.MaxDate = #1/31/2001#
.Date = #1/1/2001#
End With
|