ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   drop-down calendar (https://www.excelbanter.com/excel-worksheet-functions/111835-drop-down-calendar.html)

lizbeff

drop-down calendar
 
I'm trying to insert a drop-down calendar in an Excel form. I created an
expense report form, and would like a drop-down calendar to appear in the
column for "Expense Type".

Paul B

drop-down calendar
 
lizbeff, have a look here,

http://www.rondebruin.nl/calendar.htm
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003


"lizbeff" wrote in message
...
I'm trying to insert a drop-down calendar in an Excel form. I created an
expense report form, and would like a drop-down calendar to appear in the
column for "Expense Type".




Carolan

drop-down calendar
 
I have tried the instructions on www.rondebruin.nl/calendar.htm. However,
once I have added the Additional Controls "Calendar Control 10.0" to the
Toolbox, it shows the little icon but states it's "unknown" and when I try to
drag it to the form box I get a message "Library not registered".
What am I doing wrong?????
--
Carolan


"Paul B" wrote:

lizbeff, have a look here,

http://www.rondebruin.nl/calendar.htm
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003


"lizbeff" wrote in message
...
I'm trying to insert a drop-down calendar in an Excel form. I created an
expense report form, and would like a drop-down calendar to appear in the
column for "Expense Type".





Paul B

drop-down calendar
 
Carolan, try this

Tools references, browse to windows system, files of type activeX controls
(*.ocx) pick mscal.ocx calendar


or this

Click Start then Run and type: regsvr32 mscal.ocx and click OK:



Windows will display a message confirming that the file has been registered
successfully:



The installation process is now complete. You will probably need to restart
the program in which you want to use the Calendar Control file before it is
recognized.


--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003


"Carolan" wrote in message
...
I have tried the instructions on www.rondebruin.nl/calendar.htm. However,
once I have added the Additional Controls "Calendar Control 10.0" to the
Toolbox, it shows the little icon but states it's "unknown" and when I try
to
drag it to the form box I get a message "Library not registered".
What am I doing wrong?????
--
Carolan


"Paul B" wrote:

lizbeff, have a look here,

http://www.rondebruin.nl/calendar.htm
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003


"lizbeff" wrote in message
...
I'm trying to insert a drop-down calendar in an Excel form. I created
an
expense report form, and would like a drop-down calendar to appear in
the
column for "Expense Type".







Carolan

drop-down calendar
 
I did this and I still get the message that it is not registered. I tried
using a newer PC that already has the mscal.ocx registered and I still get
the same message that it is not registed!!!!
--
Carolan


"Paul B" wrote:

Carolan, try this

Tools references, browse to windows system, files of type activeX controls
(*.ocx) pick mscal.ocx calendar


or this

Click Start then Run and type: regsvr32 c and click OK:



Windows will display a message confirming that the file has been registered
successfully:



The installation process is now complete. You will probably need to restart
the program in which you want to use the Calendar Control file before it is
recognized.


--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003


"Carolan" wrote in message
...
I have tried the instructions on www.rondebruin.nl/calendar.htm. However,
once I have added the Additional Controls "Calendar Control 10.0" to the
Toolbox, it shows the little icon but states it's "unknown" and when I try
to
drag it to the form box I get a message "Library not registered".
What am I doing wrong?????
--
Carolan


"Paul B" wrote:

lizbeff, have a look here,

http://www.rondebruin.nl/calendar.htm
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003


"lizbeff" wrote in message
...
I'm trying to insert a drop-down calendar in an Excel form. I created
an
expense report form, and would like a drop-down calendar to appear in
the
column for "Expense Type".








All times are GMT +1. The time now is 10:15 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com