Calendar control

SlinkyWheels

Board Regular
Joined
Jan 5, 2007
Messages
217
Hi

I am currently using Excel 2003 SP2 (Standard Edition)

The company where I work has created several userforms which use the Calendar function within VB and all employees can use this.

I have since created a new set of Userforms (which do not use the calendar function) for an external company. Upon opening the spreadsheet and running the code to launch the Userform they get an error message regarding "Calendar Control".

Can anyone shed any light on this?
Sorry I can not be more specific at present.
I am totally confused.
 

Some videos you may like

Excel Facts

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.

SydneyGeek

MrExcel MVP
Joined
Aug 5, 2003
Messages
12,251
I'm guessing that you copied the form across or duplicated the file. Is that correct?

If so, it's likely to be a missing VBA reference. In the VBA environment, select Tools > References. Look at the top for something relating to a Calendar Control, and deselect it. If you do this on a machine that throws the error, it's likely to be flagged as MISSING.
Either way, deselect, click OK and you should be OK

Denis
 

noppojp

Board Regular
Joined
Nov 4, 2005
Messages
69
This didn't work for me.
i switched environments from W2K to XP.
Doesn't work in XP, but works in W2K wonderfully.
This little calendar is a lifesaver, so i need it in XP too.
Any ideas? Any takers?

Excel Version: 2003 SP2
i get an error message stating: "Object can't be read, so this form can't be used on this machine. "NOTE: That's a rough translation of the Japanese error message.
 

SydneyGeek

MrExcel MVP
Joined
Aug 5, 2003
Messages
12,251

ADVERTISEMENT

Try compiling the project (in the VBE, Debug > Compile). If there are any references in the code that cause problems, this will highlight them.
Sometimes, an error in an unrelated piece of code will cause runtime errors. It can happen when you upgrade versions.

Denis
 

noppojp

Board Regular
Joined
Nov 4, 2005
Messages
69
Thanks for the response.

i had to call the helpdesk at my company.

He said: "After I have copied MSCAL.OCX from mine to your PC and optimized some registry, it seems fine with Calendar function."

Thank You. If he had not fixed, i'd have followed your advise for sure.

:)
 

noppojp

Board Regular
Joined
Nov 4, 2005
Messages
69

ADVERTISEMENT

But, how about making the calendar do the following:

1) appear where the mouse is, instead of in the middle of the workspace?

2) Always reflect today's date

Welcome your thoughts?

From Tokyo
 

noppojp

Board Regular
Joined
Nov 4, 2005
Messages
69
Slick site Denis!
Couldn't find a way to make the Calendar pop up next to the cell, but i got it to show today's date.
Quite happy. Cheers
:pray:
 

Watch MrExcel Video

Forum statistics

Threads
1,123,125
Messages
5,599,856
Members
414,342
Latest member
K Darrell Smith

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top