I have been trying to create a pop up calendar for my workbook for a few weeks now. I would like the calendar to be compatible with 2007 and 2010 versions of excel. I have tried to follow the instructions listed at http://fontstuff.com/vba/vbatut07.htm however I can't seem to get it right.
When I try to select the MonthVeiw control I get a "class factory cannot supply requested class" error...so I tried to modify the language substituting MonthView for CalendarControl....Still didn't work.
I even tried switching computers...using a windows 7 version with excel 2010 yet the MonthView or CalendarControl aren't even options!!!
Lastly I tried the add-ins and that didn't work either. I really like to learn how to use visual basic and get this done right rather than downloading a file. Any help would be greatly appreciated.
Bookmarks