ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Help with mscal.ocx XL2002 vs XL2003 (https://www.excelbanter.com/excel-programming/337744-help-mscal-ocx-xl2002-vs-xl2003.html)

M. Authement

Help with mscal.ocx XL2002 vs XL2003
 
I created an XL add-in using the mscal.ocx controller, a drop-down box and a
couple of command buttons. Basically, the user can use the calendar control
on the form to select a date, then use the drop down menu to add a time
stamp, hit OK, and the date/time is inserted into the cell.

When I sent the .xla to someone for testing, the dates in the calendar were
so small they showed up as dots. When he looked at the calendar controls
properties, the dayfont was set to '2' and he was unable to change it. I
went back and added a DayFont.Size = 8 during the form initialize event, but
this didn't work either.

The one difference that I later found out was that I am using XL2002 on XP
SP2, while he is using XL2003 on XP SP2. Any ideas on what else I can look
at or solutions to this problem? Thanks for any help you can give me.



DM Unseen

Help with mscal.ocx XL2002 vs XL2003
 
Pls put the code in the Form activate event, not the initialize
event(Initailize event s*cks for MSFORMS)

Also he might be using different versions of the control(very probable
since he uses another office version)

DM Unseen



All times are GMT +1. The time now is 07:42 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com