ExcelBanter - Set Value for Date/Time Picker

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Set Value for Date/Time Picker (https://www.excelbanter.com/excel-programming/272212-re-set-value-date-time-picker.html)

Bill Lunney

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.

Cathy Myers

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.

.

All times are GMT +1. The time now is 05:12 PM.