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

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