have a calendar pop up in a cell to pick & insert a date in excel

How do i have a calendar pop up in a cell in excel worksheet and be able to
pick a date to be inserted in that cell?

helevansen -
Here are the steps to get what you are looking for:

1) Open the "Control Toolbox" toolbar (View->Toolbars->'Control Toolbox')
2) Click on the 'More Controls' Button (the one that looks like a hammer and
wrench)
3) Select 'Calendar Control 11.0', this will load a calendar onto your
spreadsheet.
4) Right click on the calendar and select 'View Code'
5) Paste this code:
Private Sub Calendar1_Click()
With ActiveCell
.Value = Me.Calendar1.Value
.NumberFormat = "mm/dd/yy"
.Select
End With
End Sub
6) In the "Control Toolbox" toolbar click on "Exit Design Mode" (left most
icon on the control toolbox toolbar.

This will output the current system date to the active cell when you click
on a date on the calendar.


--
Regards,
Dave


"helevansen" wrote:

> How do i have a calendar pop up in a cell in excel worksheet and be able to
> pick a date to be inserted in that cell?

I am working with Excel Calendar Object 8.0. it doesn't have an exit design
mode icon. I was able to follow steps 1 - 5 and then just closed the code
window. The calendar remains on top of the worksheet. I would like to be
able to click on the cell, have the calendar pop up while in a cell, and then
be able to pick a date and have the date appear in the cell and have the
calendar either hidden or somewhere else on the spread sheet. Does that make
it any clearer? Helen

"David Billigmeier" wrote:

> helevansen -
> Here are the steps to get what you are looking for:
>
> 1) Open the "Control Toolbox" toolbar (View->Toolbars->'Control Toolbox')
> 2) Click on the 'More Controls' Button (the one that looks like a hammer and
> wrench)
> 3) Select 'Calendar Control 11.0', this will load a calendar onto your
> spreadsheet.
> 4) Right click on the calendar and select 'View Code'
> 5) Paste this code:
> Private Sub Calendar1_Click()
> With ActiveCell
> .Value = Me.Calendar1.Value
> .NumberFormat = "mm/dd/yy"
> .Select
> End With
> End Sub
> 6) In the "Control Toolbox" toolbar click on "Exit Design Mode" (left most
> icon on the control toolbox toolbar.
>
> This will output the current system date to the active cell when you click
> on a date on the calendar.
>
>
> --
> Regards,
> Dave
>
>
> "helevansen" wrote:
>
> > How do i have a calendar pop up in a cell in excel worksheet and be able to
> > pick a date to be inserted in that cell?

helevansen

Visit Ron de Bruin's site for how to work with a calendar.

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

Note: Ron suggests Inserting the Calendar as an Insert>Object and not through
the Control Toolbox.


Gord Dibben Excel MVP

On Thu, 29 Sep 2005 12:33:02 -0700, "helevansen"
<helevansen@discussions.microsoft.com> wrote:

>I am working with Excel Calendar Object 8.0. it doesn't have an exit design
>mode icon. I was able to follow steps 1 - 5 and then just closed the code
>window. The calendar remains on top of the worksheet. I would like to be
>able to click on the cell, have the calendar pop up while in a cell, and then
>be able to pick a date and have the date appear in the cell and have the
>calendar either hidden or somewhere else on the spread sheet. Does that make
>it any clearer? Helen
>
>"David Billigmeier" wrote:
>
>> helevansen -
>> Here are the steps to get what you are looking for:
>>
>> 1) Open the "Control Toolbox" toolbar (View->Toolbars->'Control Toolbox')
>> 2) Click on the 'More Controls' Button (the one that looks like a hammer and
>> wrench)
>> 3) Select 'Calendar Control 11.0', this will load a calendar onto your
>> spreadsheet.
>> 4) Right click on the calendar and select 'View Code'
>> 5) Paste this code:
>> Private Sub Calendar1_Click()
>> With ActiveCell
>> .Value = Me.Calendar1.Value
>> .NumberFormat = "mm/dd/yy"
>> .Select
>> End With
>> End Sub
>> 6) In the "Control Toolbox" toolbar click on "Exit Design Mode" (left most
>> icon on the control toolbox toolbar.
>>
>> This will output the current system date to the active cell when you click
>> on a date on the calendar.
>>
>>
>> --
>> Regards,
>> Dave
>>
>>
>> "helevansen" wrote:
>>
>> > How do i have a calendar pop up in a cell in excel worksheet and be able to
>> > pick a date to be inserted in that cell?