calendar option???

[salcsw]

I have a large workbook that I use for my business. On each page I need to enter dates over and over again. Is there a way to format a cell so that one of those little calendars pops up every time I go to that particular cell? I'd rather click on a date on the calendar than have to input dates over and over again.
Thanks!

 

[CalcSux78]

If you're running Excel 2010, try this: <!--StartFragment-->https://sites.google.com/site/e90e50/calendar-control-class
or http://www.contextures.com/exceldatepicker.html

If you have an older version of Excel or if you have MS Access 2010 along with Excel 2010 you can use this one:
http://www.fontstuff.com/vba/vbatut07.htm


P.S. Welcome to the forum!
<!--StartFragment--><!--EndFragment--><!--EndFragment-->

 

[salcsw]

if you're running excel 2010, try this: <!--startfragment-->https://sites.google.com/site/e90e50/calendar-control-class
or http://www.contextures.com/exceldatepicker.html

if you have an older version of excel or if you have ms access 2010 along with excel 2010 you can use this one:
http://www.fontstuff.com/vba/vbatut07.htm


p.s. Welcome to the forum!
<!--startfragment--><!--endfragment--><!--endfragment-->

thank you!!!

 

[salcsw]

thank you!!