View Single Post
  #1   Report Post  
Iain the scout
 
Posts: n/a
Default 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.