Pop Up Calendar

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

phowe43 - 27 May 2008 21:22 GMT

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.

Reply to this Message

Ron de Bruin - 27 May 2008 21:33 GMT

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

Signature

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm

>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.
[quoted text clipped - 6 lines]
>
> Thanks.

Reply to this Message