Need a replacement for MS date & time picker

[antcha]

I have developed a userform that meets the needs it was designed for. However, I now find that all of the computers need to have this control activated though some are office 2013. I used the date picker as I was having trouble with using a text box for the date it would convert the date to mm/dd/yyy which fouled everything up. Is there an easy fix for the date textbox to use dd/mm/yyyy and copy that across to the workbook?

[MarvinP]

Hi antcha,

I attached an example calendar form to a answer I gave a few days back. Find the workbook at:

http://www.excelforum.com/excel-prog...t=#post4152082

See if this works for you.

[antcha]

Thanks for quick response. i will try it out as soon as I get to work in the morning

[JasperD]

Alternatively, try the one I supplied here

[antcha]

Thanks for the assistance, it has been fantastic. Have solved the issue with the date picker. However now I find that the date picker is not transferring the date to the WS. Can someone please look at my little project to see what I have missed. As a newbie I must say this forum is the best I have seen.
wip Date_Group Sessions.xlsm

[mikerickson]

Here is a date picker that I wrote for Mac.

It is worked by a syntax like this. (macDate is the name of the user form.)

Please Login or Register  to view this content.

[antcha]

Thanks, mikerickson, my calendar is working. it is just not picking up the date to add to the worksheet. I am missing something in the code but too much inexperience is not allowing me to work out where the code is at fault.

[JasperD]

in your 'save_click' sub, change

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

Please click the * below if this helps

[antcha]

Thanks JasperD. When you run the userform it still does not transfer the date to the DATA WS

[antcha]

my apologies, mate. Must be my fat fingers. Works perfectly now. Many Thanks

[antcha]

I cannot thank you guys enough for the valuable assistance given to this old fella.