DTpicker on 64bit

fraufreda

Board Regular
Joined
Oct 14, 2010
Messages
190
I'm using a userform where a date is selected from DTpicker. I developed it initially on 32bit so I didn't encounter this issue.
In an attempt to make it work on 64bit I downloaded add-in from Date Picker Add-in for Excel for Windows

But an error comes up when calling the procedure in a userform. plus I don't how to make the value of the selection affect a textbox in the userform.
Code:
   call ronaddin
   textbox1.value = selectedDate

I tried another workaround solution by creating a list of dates that are linked to a combobox but I've got another problem and now it's with the date format. whenever the combobox is changed the date converts to a number and error comes when using the format property

Code:
combox.value = format(combobox.value,"mm/dd/yy")

I would prefer if I can get Ron's add-in to work but if there is no chance then what is the equivalent for the FORMAT property in 64bit office 2016.

thank you
 

Excel Facts

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.

Forum statistics

Threads
1,213,520
Messages
6,114,101
Members
448,548
Latest member
harryls

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top