ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Help Please!!!!! (https://www.excelbanter.com/excel-discussion-misc-queries/186489-help-please.html)

DavisGJD

Help Please!!!!!
 
How do I click on a cell and have an appointment calendar pop up, click on
the time and date and have it fill the cell with just the time and date?

Jim Thomlinson

Help Please!!!!!
 
Here is how I would do it. Select Tools - Customize - Toolbars (tab) and
check Control Toolbox. This will bring up the Control Toolbox Toolbar. Click
the icon that looks like a Hammer and Wrench. From the list choose Microsoft
Date and Time Picker Control. Your cursor will change to a cross hair that
you can use to draw the control (the same way you would draw a rectangle
using click and drag). Right click the control and select Properties. Add a
cell reference (such as A1) to the Linked Cell property. Now to get out of
design mode click on the Triangle & Ruler icon on the control toolbox
toolbar.

--
HTH...

Jim Thomlinson


"DavisGJD" wrote:

How do I click on a cell and have an appointment calendar pop up, click on
the time and date and have it fill the cell with just the time and date?



All times are GMT +1. The time now is 02:28 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com