How can I insert a date with an icon (calendar) insert

's Computer Specifications

How can I insert a date in a cell with a calendar icon insert that can help
me to find in a easy way a specifically day by pointing day, month even year.
It is usual in many work spreadsheet but i couldnt find in Excel..
Thanks.

's Computer Specifications

Check out the control at this link...it will definately help

http://blogs.msdn.com/excel/archive/...e-pickers.aspx

--
Pranav Vaidya
VBA Developer
PN, MH-India
If you think my answer is useful, please rate this post as an ANSWER!!

"Alfredo Mederico" wrote:

> How can I insert a date in a cell with a calendar icon insert that can help
> me to find in a easy way a specifically day by pointing day, month even year.
> It is usual in many work spreadsheet but i couldnt find in Excel..
> Thanks.

's Computer Specifications

See how Ron de Bruin does it.

http://www.rondebruin.nl/calendar.htm

Note the "more information" link to download mscal.ocx if needed.

Gord Dibben MS Excel MVP

On Thu, 20 Sep 2007 10:22:02 -0700, Alfredo Mederico
<(E-Mail Removed)> wrote:

>How can I insert a date in a cell with a calendar icon insert that can help
>me to find in a easy way a specifically day by pointing day, month even year.
>It is usual in many work spreadsheet but i couldnt find in Excel..
>Thanks.

's Computer Specifications

Excellent Vaidya...!!!
Definitely it helps me...
Thanks!!!

"Pranav Vaidya" wrote:

> Check out the control at this link...it will definately help
>
> http://blogs.msdn.com/excel/archive/...e-pickers.aspx
>
> --
> Pranav Vaidya
> VBA Developer
> PN, MH-India
> If you think my answer is useful, please rate this post as an ANSWER!!
>
>
> "Alfredo Mederico" wrote:
>
> > How can I insert a date in a cell with a calendar icon insert that can help
> > me to find in a easy way a specifically day by pointing day, month even year.
> > It is usual in many work spreadsheet but i couldnt find in Excel..
> > Thanks.

's Computer Specifications

Thanks Gord...!!!!

"Gord Dibben" wrote:

> See how Ron de Bruin does it.
>
> http://www.rondebruin.nl/calendar.htm
>
> Note the "more information" link to download mscal.ocx if needed.
>
>
> Gord Dibben MS Excel MVP
>
>
> On Thu, 20 Sep 2007 10:22:02 -0700, Alfredo Mederico
> <(E-Mail Removed)> wrote:
>
> >How can I insert a date in a cell with a calendar icon insert that can help
> >me to find in a easy way a specifically day by pointing day, month even year.
> >It is usual in many work spreadsheet but i couldnt find in Excel..
> >Thanks.
>
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Pop-up Calendar won't insert date into document	JFREE223	Microsoft Word Document Management	6	4th Mar 2008 01:22 PM
How to insert date using a pop up calendar control in a cell in E.	=?Utf-8?B?c2lubmVkODE=?=	Microsoft Excel Misc	7	16th Oct 2006 09:16 AM
How to insert auto populate calendar icon?	=?Utf-8?B?QW5pdGE=?=	Microsoft Excel Misc	2	22nd Apr 2006 01:15 AM
Insert Date From Calendar In Control	Lirva Smith via AccessMonster.com	Microsoft Access Forms	1	26th May 2005 03:55 PM
How do I insert an icon onto outlook calendar	=?Utf-8?B?cmZoYWxsNTI3?=	Microsoft Outlook Calendar	1	23rd Jan 2005 03:21 PM