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

[Guest]

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?

 

[Guest]

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.

 

[Guest]

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

 

[Gord Dibben]

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