| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Populating a Date-formatted Cell with ActiveX Calendar Control
Can anyone share with me how to click in a cell and have the calendar open,
and populate the cell with the calendar value you select? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Populating a Date-formatted Cell with ActiveX Calendar Control
Probably your best option will be to embed a Date & Time Picker Control into
your spreadsheet. Bring up the Control Toolbox. Click on the More Controls button (Hammer and Wrench) Select Microsoft Date and Time Picker Control Draw the control over top of the cell you want. Right click the control and select Properties In the linked cell property add the cell reference -- HTH... Jim Thomlinson "Jim Lawrence" wrote: Can anyone share with me how to click in a cell and have the calendar open, and populate the cell with the calendar value you select? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Why activex calendar control 12 missing in Excel 2007 SP1? | Excel Programming | |||
| Format entire column with Calendar activex control? | Excel Discussion (Misc queries) | |||
| How to insert date using a pop up calendar control in a cell i | Excel Discussion (Misc queries) | |||
| how do you use the ActiveX Calendar control in an Excel Worksheet. | Excel Worksheet Functions | |||
| ActiveX Error w/Calendar Control | Excel Programming | |||
![Jim Lawrence[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
