| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date ??
I am using the "calendar control" to select a date that is used further down in my script. What I want to do is make sure the when the form is diplayed and the calander comes up it is set to today dates. This not happening. What is the trick to control the date value in the calendar control? TI
Sub cPickDate_Click() <----this is the calendar contro theDate = cPickDat theDate = Format(theDate, "mm/dd/yyyy" End Su |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Date ??
Hi Greg
Calendar1.Value = Date For more info see http://www.rondebruin.nl/calendar.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Greg" wrote in message ... I am using the "calendar control" to select a date that is used further down in my script. What I want to do is make sure the when the form is diplayed and the calander comes up it is set to today dates. This not happening. What is the trick to control the date value in the calendar control? TIA Sub cPickDate_Click() <----this is the calendar control theDate = cPickDate theDate = Format(theDate, "mm/dd/yyyy") End Sub |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Date ??
In the UserForm_Activate event, put
cPickDate.Value = Now() -- Message posted from http://www.ExcelForum.com |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Concatenate including a date so that the date appears as a date | Excel Worksheet Functions | |||
| date in Cell to change colors if the date is beyond today's date | Excel Discussion (Misc queries) | |||
| Making a date go red, if date passes todays date. | Excel Worksheet Functions | |||
| Report Date - Date Recv = Days Late, but how to rid completed date | Excel Worksheet Functions | |||
| Date updates from worksheet to chart & changes date to a date series! Help!! | Charts and Charting in Excel | |||
Linear Mode
