LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Insert date in macro George Gee New Users to Excel 12 April 17th 06 05:44 AM
insert the date the file was last modified Hoff Excel Discussion (Misc queries) 8 November 21st 05 01:31 PM
Challenging Charting C TO Charts and Charting in Excel 0 January 17th 05 06:57 PM
Calendar date function John Excel Discussion (Misc queries) 1 January 7th 05 06:08 PM
Calendar and info for that date Jenn Excel Discussion (Misc queries) 0 January 5th 05 04:21 PM


All times are GMT +1. The time now is 11:58 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"