How to have a pop up calendar in Excel
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
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
I believe that is from brettdj...
Ng,
Ng,
ASKER
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."
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,
"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,
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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Here is how to do it.
http://www.fontstuff.com/vba/vbatut07.htm