userform date output

[miaousse]

hello,

in a userform how can i retrieve the output of a date picker and do some stuff with it?

my userform will include the date picker and a checkbox .
if the checkedbox is selected, i retrieve the output of the date picker to make the date dd/mm/yyyy to be yyyy mm dd

[Tom]

This can be done with a Selection Form macro - use DateTime control. You can also set the date format.