Pop Up Calendar

[phowe43]

I used Ron deBruin information to had a drop down calendar to a worksheet
(actually multiple). Worked fine at first but I must have changed something.
First, the calendar date "default" is one day in advance. In other words
today is 5/27/08...but the default when the calendar comes up is showing
5/28/08. Second problem is that the numbers and information on the calendar
is so small that it is not viewable.

What have I done wrong.

Thanks.

 

[Ron de Bruin]

Hi phowe43

The control not like changing the zoom of the worksheet
Try this Delete the control and add it again

The code is using this line to set the date
Calendar1.Value = Date


What result give this macro

Sub testdate()
MsgBox Date
End Sub