| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Set Value for Date/Time Picker
activesheet.oleobjects(1).object.value="10/10/2003"
Replace the 1 with whatever is the name of your dtp control -- Regards, Bill Lunney www.billlunney.com "Cathy Myers" wrote in message ... Hi, How do I set the default value for a date/time picker using code. I am new to both Excel and VBA. Thanks. C.M. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Set Value for Date/Time Picker
Thanks.
C.M. -----Original Message----- activesheet.oleobjects(1).object.value="10/10/2003" Replace the 1 with whatever is the name of your dtp control -- Regards, Bill Lunney www.billlunney.com "Cathy Myers" wrote in message ... Hi, How do I set the default value for a date/time picker using code. I am new to both Excel and VBA. Thanks. C.M. . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Date and Time Picker - two an issue? | Excel Discussion (Misc queries) | |||
| Using the Microsoft Date and Time Picker 6.0 | Excel Worksheet Functions | |||
| pop up Date time picker | Excel Discussion (Misc queries) | |||
| Date Time Picker | Excel Discussion (Misc queries) | |||
| Date and Time Picker | Excel Discussion (Misc queries) | |||
Linear Mode
