VBA Calendar Control does not show day numbers. ??

Hi,

Over in the following thread

http://www.excelforum.com/showthread...=1#post1946987

you can see we've hit a problem with the Calendar Control object.

I submitted a workbook which has an Activex calendar control embedded on a User Form. On my PC everything appears as you'd expect, with the calendar showing the individual days in the calendar matrix. However when the user loads the form on their system, although they see the calendar as you'd expect, and they can change the month & year at the top of the calendar, they don't see the individual day numbers, 1,2,3 etc. within the body of the calendar.

Can anyone shed any light on what the problem might be? The original thread contains a picture image of the calendar showing the 'missing' days.

Regards and usual TIA

Bump... If anyone has an idea on how to fix the above issue I would appreciate the help.

VBA Noob[/QUOTE]

Hi VBA N

Thanks for the link but I don't think this helps. The user has the calendar control object ticked in the VBE, and indeed can see the calendar control. It's just that the little matrix of boxes containing the days 1-31 has no numbers in it - weird because it works fine on my PC.

Rgds

They might be missing some screen font.

Is there some where I can edit the code for the actual calander to see what font is being used?

It may be a common font or not one at all. To see if it is a font issue, go to your Fonts folder and copy all the fonts. In the other user's Font folder, move his to some other Folder. Then paste your fonts into his folder.

A google search for: XP "Missing Fonts", might show which screen fonts that might be the problem.

You might also try changing the default printer.

Changing screen resolution might help but I doubt it.

Hi,

That's a good point Kenneth makes about the screen fonts. Unfortunately I use a Mac for most things, and this doesn't have the VBA syntax for calendar controls, and ironically the old Windows PC I used to test the original code has just died on me, so I can't check this out. However if you go into the VBE, select the User form and click on the calendar object, then look for the Font property in the Properties window, you should be able to change it to one which is recognised by your PC.

Failing that of course we can just go back to the original idea of having the user enter the date in an input box, which isn't quite as elegant, but will get you going. Let me know how you get on.

Regards,

R.

Good point Richard. The GridFont Propterty on mine is Regular Arial 8 Western script. So, the other user most likely has that font missing or it is corrupt. Use the method that I detailed to copy or add a good font.