Date widget for entering dates?

**puch2** · 10-06-2008, 05:29 PM

Is there a way to configure Excel so that I can use a date widget to enter dates? I would like to be able to pick from a widget that looks like a month calendar instead of having to enter 10/09/2007 into a cell.

Thnak you in advance.

**shg** · 10-06-2008, 05:31 PM

Search the forum for calendar control to find lots of examples.

**arthurbr** · 10-10-2008, 05:13 AM

Ctrl + ; also enters the current date

**stevesunfold** · 10-11-2008, 04:55 PM

puch this has helped me a lot

http://www.excelforum.com/excel-prog...-up-query.html

**VBA Noob** · 10-11-2008, 05:00 PM

Download the add-in from here

http://www.fontstuff.com/vba/vbatut07.htm

The right click menu as the option to add date which brings up a calendar to select from

VBA Noob