We help IT Professionals succeed at work.

How to have a pop up calendar in Excel

billelev
billelev asked
on
1,536 Views
Last Modified: 2012-05-09
I have the following file that brings up a pop up calendar.  However...to get it to work I had to download and install an Active-X control.  I want to distribute this capability to others who may not have that file, nor will want to install it.

Does anyone know of a way to have a pop up calendar functionality without the need to install additional files?  The ultimate aim is to control date input and make it easy and full proof. Calendar.xls
Comment
Watch Question

Rick HobbsRETIRED
CERTIFIED EXPERT
Top Expert 2006

Commented:
A VBA calendar will use the ActiveX control that install with Excel.
  Here is how to do it.

http://www.fontstuff.com/vba/vbatut07.htm
See if this will help....

http://www.rondebruin.nl/calendar.htm

NG,
I believe that is from brettdj...

Ng,

Author

Commented:
The first link is what I originally used...And it is where the file is from.  

The second link references the first.

I thought we weren't allowed to post links on this site, otherwise I would have provided the links originally.  As you will see from the first link,

"NOTE: The Calendar Control is an ActiveX control (actually a file called mscal.ocx) supplied with Microsoft Office. It is normally installed with a standard installation of Microsoft Office Professional or Microsoft Access, but if you can't find it on the list you will need to get hold of a copy. If you are distributing your file, or planning to use it on more than one computer, you will also need to make sure that the host computer has the mscal.ocx file installed. You will find it on the CD that your copy of Microsoft Office Professional came on, or you can download a copy from here."
Since the OP was requesting something that has been requested on the site a number of times I don't see the need to recreate the wheel each time a repeat question is asked, an external link is more efficient and I think appropriate.

"I thought we weren't allowed to post links on this site, otherwise I would have provided the links originally.  As you will see from the first link,"

If we aren't allowed to post links then why did you post a link?

Brad is summarizing the implementation of the Calendar control and his usage so you don't have to digest every nuance of a calendar control.

Either way I think the OP will have enough information to solve the Calendar problem that they are having.

Please feel free to post any questions with regard to implementation and we'll try to help.

NG,
Rick HobbsRETIRED
CERTIFIED EXPERT
Top Expert 2006

Commented:
You can't post links that are considered advertising or spam.  You can point links that give a detailed solution to the problem asked.

I often give a link to an existing answer in Expert's Exchange if it references a solution to the question being asked.

I would recommend you provide a little text file explaining the need for the ActiveX file, the fact that it is a Microsoft supplied file, and the a link to the file or the file itself.
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.