How to insert date using a pop up calendar control in a cell i
 

Ist it possible to link the date reurned from the calender into a formula in
another cell to perform date maths. If so how can I do it?


"Hayeso" wrote:

1. View..ToolBars...Control Toolbox
2. Click the button for More controls (looks like two hammers)
3. From the list Select "Microsoft Date Time Picker "
4. Drag on sheet for the size of the control
5. Turn off design mode (green triangle on the control toolbox) to use the
DT control



"sinned81" wrote:

It has to be simple to add a control to an excel worksheet so when a user
clicks on a cell a calendar pops up allowing the selection of a date.

I just can't figure out how to do it.

hi.. under more controls, i do not have a selection called "microsoft date
time picker".. i am using excell ver 2003

"Iain the scout" wrote:

Ist it possible to link the date reurned from the calender into a formula in
another cell to perform date maths. If so how can I do it?


"Hayeso" wrote:

1. View..ToolBars...Control Toolbox
2. Click the button for More controls (looks like two hammers)
3. From the list Select "Microsoft Date Time Picker "
4. Drag on sheet for the size of the control
5. Turn off design mode (green triangle on the control toolbox) to use the
DT control



"sinned81" wrote:

It has to be simple to add a control to an excel worksheet so when a user
clicks on a cell a calendar pops up allowing the selection of a date.

I just can't figure out how to do it.

Hi

Check out this free in cell datepicker.


http://www.isamrad.com/excelcal/

HTH

Ken

The ms datepicker is part of the ms common controls ocx (MSCOMCT2.OCX)
usually found in the windows\system or windows\system32 folder.

Ken

How to insert date using a pop up calendar control in a cell i
 

Hi Ken,

is it possible to get these controls ? I did a search and I get the
impression you need Visual Basic. I simply would like to have these controls
to use in Excel.

thank you

Pierre

"Ken Macksey" wrote:

The ms datepicker is part of the ms common controls ocx (MSCOMCT2.OCX)
usually found in the windows\system or windows\system32 folder.

Ken