frmCalendar

I have a worksheet which last year had a working frmCalendar in it.
This year when I click on the same macro button that called up the calendar, it says 'Compile Error' 'Variable not defined'
I have had a look at the properties of my macro and when I call up frmCalendar, the form appears but no calendar.
Don't know where it went or how I get it back.
I have had a look in the Additional Controls list to see if I can get another calendar but there is'nt one in the list.
Any ideas ??

If I remember correctly the calendar control does not come as part of excel and there have been many different and incompatible versions of calendar controls in the past.

The chances are that either the calendar control you were using has been superseeded or that you are running on a pc that does not have it installed.

When you bring up a used form in VBA you will see the controls toolbar the calendar should appear on that. If not rightclick the toolbar and it will offer the option of additional controls. This will list all available controls installed on your pc.

I have two calendar controls installed and the useful MSDateandTimePicker control which is a nice simple thing to use for selecting dates.

Hope this helps

Hi,

It is a two step process to fix your Calendar Control ...

1. Make sure to copy the file mscal.ocx in its directory C:\Windows\System32

2. Then you have to register this control, by doing the following :
Click Start then Run and type: regsvr32 mscal.ocx and click OK

HTH
Carim