MISSING: Microsoft office project 12.0 calendar Control for excel 2013

Hello everyone!

I've just recieved an excel sheet with Macros made in Microsoft Office Excel 2010 and it does not work in 2013!

I've tried googled for help but i've not found anything that helped!

I dont know how to use macros so i consider myself a noob in this matter, yet i have to find a solution :)

http://s000.tinyupload.com/?file_id=09240564222934784736 - the file that i need help with

Thanks in advance


  • Edited by Shadowdorg Wednesday, August 12, 2015 9:16 AM
August 12th, 2015 9:13am

I have replaced the date picker control with a text box.

Free Windows Admin Tool Kit Click here and download it now
August 13th, 2015 6:19am

If you mean the text box on the userform, you could change the event procedure

Sub UserForm_Initialize()
    DTPicker1.Value = Date
End Sub

to

Sub UserForm_Initialize()
    DTPicker1.Value = Format(Date, "dd.mm.yyyy")
End Sub

If, on the other hand, you mean the values returned in the cells on the worksheets, you only need to set the number format of those cells to dd.mm.yyyy. This is a one-time action.

August 13th, 2015 8:28am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics