Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 94
Default 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.


  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 233
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
MSCAL.OCX C Weber Excel Programming 0 July 22nd 04 07:03 PM
MSCAL.OCX Chas Weber Excel Programming 0 July 22nd 04 06:35 PM
mscal.ocx nath Excel Programming 0 September 17th 03 11:11 AM
mscal.ocx nath Excel Programming 0 September 17th 03 10:46 AM
mscal.ocx nath Excel Programming 0 September 10th 03 12:57 PM


All times are GMT +1. The time now is 01:51 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"