Date time picker control

xiaowang · Jan 22nd 2020

Hi OZgrid currently my date time picker control is only able to allow people select the date however i would like it to select the time as well is this posssible? please do advise!

**Carim** · Jan 22nd 2020

Hello,

There are many different datepickers ...

Which one are you using ???

**royUK** · Jan 22nd 2020

Look at these free non-activeX controls

Alternate DatePickers for Excel

**Carim** · Jan 22nd 2020

Re,

For 64 bit Excel, you can use either Sam Radakovitz's or Ron De Bruin's Date Picker Add-in :

http://samradapps.com/datepicker/

http://www.rondebruin.nl/win/addins/datepicker.htm

Hope this will help

xiaowang · Jan 22nd 2020

Quote from Carim

Re,

For 64 bit Excel, you can use either Sam Radakovitz's or Ron De Bruin's Date Picker Add-in :

http://samradapps.com/datepicker/

http://www.rondebruin.nl/win/addins/datepicker.htm

Hope this will help

Display More

hi carim im unable to use non active x tools due to user account privileges. hence i would be using the microsoft date time picker for 32bit. do advise.

**Carim** · Jan 22nd 2020

Hi,

Could you at least the post the instruction you are using to store the Date from your Calendar ....

xiaowang · Jan 22nd 2020

Quote from Carim

Hi,

Could you at least the post the instruction you are using to store the Date from your Calendar ....

Code

Cells(erow, 3) = DTPicker1.Value

Hi carim here it is

**Carim** · Jan 23rd 2020

Hello,

You could test following

Code

Cells(erow, 3) = Evaluate("=INT(DTPicker1.Value)+MOD(NOW(),1)")

Hope this will help

**royUK** · Jan 23rd 2020

You will probably get problems with the activeX controls, that's why I suggested non-activeX which have no problems like that and work in 32 bit and 64 bit versions.

If you really need to use the DatePicker then you need to check if it's available on each computer and if not install it.

Installing the Date Picker

xiaowang · Jan 26th 2020

Quote from Carim
Hello,

You could test following
Code
Cells(erow, 3) = Evaluate("=INT(DTPicker1.Value)+MOD(NOW(),1)")
Hope this will help
Display More

hi carim ive tried replacing the code with the one i have it does not work but thanks!

**royUK** · Jan 26th 2020

Have you read my posts?

xiaowang · Jan 26th 2020

Quote from royUK

Have you read my posts?

Yes i am aware it only works on 32bit system, however there are no other options as the computers do not have administrator exercise hence unable to put in addins

**royUK** · Jan 26th 2020

If you can use VBA then you can add one of the non-activeX alternatives from my web site

Date time picker control

Participate now!

Share