|
pop up calender PT 2
Thanks Jim
This is what I needed but I am having a problem connect the date to a cell that will work with the VLOOKUP attached Can this date be tied to the cell? You can try the Microsoft Date and Time Picker control. Add the Control Toolbox menu to your toolbars. Select the last button that looks like a hammer and wrench. Select the Microsoft Date and Time Picker Control. Add that to your sheet. -- HTH... Jim Thomlinson "Norm" wrote: Is there a pop up calender that can be embedded when sharing or emailing worksheets? Thanks Was this post helpful to you? |
pop up calender PT 2
Put the workbook in design mode by clicking on the design button on the
control toolbox (first icon that looks like a triangle, pencil and ruler) Right click on the Date Picker and select Properties Add a cell reference to the Linked Cell property. -- HTH... Jim Thomlinson "Norm" wrote: Thanks Jim This is what I needed but I am having a problem connect the date to a cell that will work with the VLOOKUP attached Can this date be tied to the cell? You can try the Microsoft Date and Time Picker control. Add the Control Toolbox menu to your toolbars. Select the last button that looks like a hammer and wrench. Select the Microsoft Date and Time Picker Control. Add that to your sheet. -- HTH... Jim Thomlinson "Norm" wrote: Is there a pop up calender that can be embedded when sharing or emailing worksheets? Thanks Was this post helpful to you? |
| All times are GMT +1. The time now is 12:53 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com