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.
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
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
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