Excel 2010 Calendar

[Baldoraxx]

Hey guys,

At work and was wondering if anybody had a calendar code i code drop into my macros for excel? While setting up my personal job tracker the calendar will function as me clicking in the cell, calendar pops up, pick the date i received notes (box color blue) and then in the cell next to it will be my deadline date, same process as received (box color red). On hand does anyone have a code for this I would be overjoyed and not have to sick Chuck Norris on you

Or you can point me in the right direction I suck at writing code.

Thanks guys and gals

 

[ToxicAsF]

http://www.wikihow.com/Create-a-Calendar-in-Microsoft-Excel ??

Edit: 10 seconds of some google-fu.

 

[Baldoraxx]

That one is 2007 i think, Layout for 2010 is different. I googled quite a bit but i couldn't find codes but a lot of how to. Being lazy and not wanting to write the code myself

 

[Andrewjo]

You can achieve that using the ActiveX control. Since you are using 2010 click the File tab, choose Options and in the Excel Options dialog choose Customize Ribbon. Go to the Main Tabs section check the box marked Developer then click OK to return to Excel.
Then click the arrow for more controls and select the date and time picker. You can link to a cell and activate the calender.
http://www.fontstuff.com/excel/exltut03.htm.
You can decide to use a template as mentioned here http://www.techyv.com/questions/need-table-calendar-2011-template.
Go through these options and see if its what you are looking for.

 

[Baldoraxx]

You can achieve that using the ActiveX control. Since you are using 2010 click the File tab, choose Options and in the Excel Options dialog choose Customize Ribbon. Go to the Main Tabs section check the box marked Developer then click OK to return to Excel.
Then click the arrow for more controls and select the date and time picker. You can link to a cell and activate the calender.
http://www.fontstuff.com/excel/exltut03.htm.
You can decide to use a template as mentioned here http://www.techyv.com/questions/need-table-calendar-2011-template.
Go through these options and see if its what you are looking for.

Thanks, that helped alot. Just what i was looking for