![]() |
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. |
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