DTPicker default value change to current date

[Lalie]

Hi

I can not get my DTPicker to change the default value to the current day. I read through all the posts i could find and did all the recommended changes. I still can't fix it. It keeps on giving the date that I inserted the DTPicker.

If there is an easier method on to entering time into a cell.

Please advise

[alansidman]

If you are looking to enter today's date then Control + ;

[Lalie]

Thanks for the help. I could not get it to work with Control +; so i just subtracted the creation date from the current date and added the number of days to the output cell.

I know this is a stupid solution but it works.

[:) Sixthsense :)]

Why not Now() function

=NOW()

=TEXT(NOW(),"HH:MM:SS")

[Lalie]

What I want from the DTPicker is just the time entered with the current date. It is for automation purposes for log sheets. I don't want the current time as well since the operators can be a bit late and I want them to enter the time. If i use the now function it gives the current time and date.

[:) Sixthsense :)]

Then why not simply Ctrl+Shift+Semicolon

[Lalie]

I am not sure what you mean. . .

[:) Sixthsense :)]

I am not sure what you mean. . .

Then why not simply Ctrl+Shift+Semicolon

I want them to enter the time. If i use the now function it gives the current time and date.

.................................

[Lalie]

Thanks but the operators will not be able to handle a simple thing like Ctrl+Shift+Semicolon. They need it as simple as possible but it works fine by adding the difference between the days.

[:) Sixthsense :)]

Just ask them to keep in memory that using the

Ctrl+Semicolon will Add the Current Date in Cell
Ctrl+Shift+Semicolon will Add the Current Time in Cell

Or

Copy the below code and do right click on sheet tab and paste the code. Return to excel and do DOUBLE click on any of the cell on that sheet, which will add the current time in the selected cell.

Please Login or Register  to view this content.

[Lalie]

Thanks I will see if that works

[:) Sixthsense :)]

You're Welcome