Date/Time picker methods

[Jag108]

Hi, I am trying to use miltiple date time pickers set to use the time as
their input from the user. My problem is I need to have some of them load on
the form in an active state with the check box visible, but not checked. So
if need be, the user can check the check box to activate the DTPicker.
I am using Excel 2003, VBA with ActiveX Date/Time picker Versin 6 (sp4).

This is a timesheet, collecting start and finish times from employees, so
Saturdays and Sundays will have the option to use or not, but the default
state is not active for weekend days.

Any help will be appreiciated.

[luo]

try : dtpicker1.value=""

"Jag108" wrote:

> Hi, I am trying to use miltiple date time pickers set to use the time as
> their input from the user. My problem is I need to have some of them load on
> the form in an active state with the check box visible, but not checked. So
> if need be, the user can check the check box to activate the DTPicker.
> I am using Excel 2003, VBA with ActiveX Date/Time picker Versin 6 (sp4).
>
> This is a timesheet, collecting start and finish times from employees, so
> Saturdays and Sundays will have the option to use or not, but the default
> state is not active for weekend days.
>
> Any help will be appreiciated.