Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pop Up Calendar
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pop Up Calendar
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 -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "phowe43" wrote in message ... 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
find free sharware to include calendar pop or use calendar in cell | Excel Discussion (Misc queries) | |||
how do i export excel calendar info to outlook calendar? | Excel Discussion (Misc queries) | |||
Calendar | Excel Discussion (Misc queries) | |||
excel calendar - list of names displayed on calendar | Excel Worksheet Functions | |||
import calendar items from excel into outlook calendar | Excel Discussion (Misc queries) |