Problem with a calendar

Hi Ortz,

Unfortunately, I was unable to get your Calendar to work.

I have another calendar that looks almost identical, that I replaced it with in the attached file, that is a copy of your file. Please note that I am using Excel 2003, and your file format may be compromised. After testing my file for suitability, do the following to port my code to your file:
a. Export UserForm module 'CalendarForm' from my file.
b. Export Module 'ModCalendarForm' from my file.
c. Import UserForm module 'CalendarForm' to your file.
d. Import Module 'ModCalendarForm' to your file.
e. Cut and paste the following code from the 'Caseloads' sheet module to the 'Caseloads sheet module in your file.

Please Login or Register  to view this content.

Please note that the code (except for the Sheet 'Caseloads' code which is customized to your application) is identical to the code from post #2 in the following thread:
http://www.excelforum.com/excel-gene...-combobox.html

Lewis

Hi LJMetzger

Thanks for having a look at this. Your version works great after I imported your Calendar and altered the code in the Caseload sheet but the only problem is the Calendar only shows January, none of the other months in the year. Any thoughts or help on that ?

Much appreciated.

Ortz

Hi jaslake

Thank you very much, greatly appreciated that works exactly how it is needed.

Thanks both for all your help with this

Ortz

I downloaded your files...yours works great...my issue is very "amateur:..

Once I have all the VBA code, modules etc. How do I assign it to a cell in my spreadsheet?