Calender Pop-Up

[Frikkels]

Hi,
I need a calender/s on a spreadsheet, the thing is i have read up on
, but which control do i need to select, the only one that i
can manage to insert is the "Microsoft date and time picker control 9.0 SP4"
but what will the code be behind this control be, where will i put the code -
against the spreadsheet or control, and then also i want to be able to use
this workbook on different PC's.

Assistance will be greatly appreciated

 

[Jacob Skaria]

Ron has mentioned in that page on what to do if the control is missing. Refer
the bottom of that page..to download..
http://www.rondebruin.nl/calendar.htm


'Also you may refer the below lin
http://danielcurran.com/instruction...r-menu-in-excel-choose-a-date/comment-page-1/

If this post helps click Yes

 

[muddan madhu]

open excel workbook
Go to “Developer Tab” in Ribbon.
( if you are not able find that in your workbook follow these steps
1. Click office button
2. Click excel options
3. Select Popular
4. Right hand side – check the option view developer tab in the ribbon

Under developer tab
Select insert drop down
Click on more controls
Now select calendar control xx.0
Drag it excel workbook.

Then follow what ron said here
http://www.rondebruin.nl/calendar.htm