Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calender Help
I have a userform which uses the Calender Control but I need the calender to
show todays date, I also have a probloem when I access this file on another computer on my network The font size of the calender is impossible to see. When I try to change the font size it comes up with the error - object not found. I copied the file to the computer which I was using by a disc, and the same problem happened. The excel where the project was first written was office pro 2003, the other computer is running office 2000 Thanks in advance Greg |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calender Help
Not sure about the "object not found error", but this is what I use to
display the Calendar Control: Option Explicit Sub ShowCalendar() Dim newDate As String Load frmCal newDate = Format(Now(), "mm/dd/yyyy") frmCal.Calendar1.Value = newDate frmCal.Show End Sub I hope that helps. -- Regards, Ron |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
pop up calender | Excel Discussion (Misc queries) | |||
pop up calender | Excel Discussion (Misc queries) | |||
pop up calender | Excel Discussion (Misc queries) | |||
Calender Help | Excel Worksheet Functions | |||
Calender Help | Excel Programming |