Pop Up Calendar

  • Thread starter Thread starter phowe43
  • Start date Start date
P

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.
 
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
 
Back
Top