| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
dtpicker to display current date when form opens
I have a DT picker in a userform. I would like it to display the current date
on opening. Your assistance with this would be much appreciated. -- Thanks Ron |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
dtpicker to display current date when form opens
I don't know what date picker you're using, but maybe...
Option Explicit Private Sub UserForm_Initialize() Me.Calendar1.Value = Date End Sub ron mann wrote: I have a DT picker in a userform. I would like it to display the current date on opening. Your assistance with this would be much appreciated. -- Thanks Ron -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
dtpicker to display current date when form opens
Hi Dave,
I am using DT picker and the suggested initialisation has worked a treat. Many thanks to you. Cheers Ron "Dave Peterson" wrote: I don't know what date picker you're using, but maybe... Option Explicit Private Sub UserForm_Initialize() Me.Calendar1.Value = Date End Sub ron mann wrote: I have a DT picker in a userform. I would like it to display the current date on opening. Your assistance with this would be much appreciated. -- Thanks Ron -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Display current date on chart | Excel Discussion (Misc queries) | |||
| need info to display only after date is current and stay there | Excel Discussion (Misc queries) | |||
| Current Date Code in form | Excel Discussion (Misc queries) | |||
| Have current date display in File Name | Excel Programming | |||
| Can I display the current date in a text box? | Excel Discussion (Misc queries) | |||
Hybrid Mode
