Pop Up Calendar

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.
 
R

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top