Thread: Microsoft Excel
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
ShaneDevenshire ShaneDevenshire is offline
external usenet poster
 
Posts: 2,344
Default Microsoft Excel

Hi,

There is one built in to Office?. Here is how you add it to the screen:
1. Choose View, Toolbar, Control Toolbox.
2. Click the More controls button, the bottom button.
3. Scroll the list and select Calendar Control 11.0 or some such number.
4. Click in the spreadsheet. You will have a calender in the spreadsheet.
It can also be added to a user form.
5. you can add code to have it put the date the user picks into particular
cell(s)



--
Thanks,
Shane Devenshire


"Jeff" wrote:

Just explored the Date Validation for drop down menu's, it is very helpful.

Wondering if there is an option to add a calender similar to the drop down
menu, we use a spreadsheet to track jobs and enter dates all the time, would
be nice if a calender would be availible for those cells.

Thanks