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.
|