Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 29
Default calendar userform

Hi,
I just tried using a userform with a calendar control that works with excel 2002 on a machine with excel 2003. It didn't work. What files need to be in whcih folders to get a calendar control for excel 2003?

peter


  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,327
Default calendar userform

Hi Peter

I think it's either mscal.ocx (installed with Access and downloadable from
the web, do a Google search) or a licensed mscomct2.ocx (installed and
licensed with Visual Studio).

Allow me to spend some room for some cool lyrics by one of the finest
american composers:

SUNDAY

Sunday?
WOW!
SUNDAY,
'MONDAY

SUNDAY,

SATURDAY. . .TUESDAY THROUGH
- MONDAY'!

SATURDAY. . .

And thus THE CALENDAR,
In all of its colorful disguises
Was presented to
The bored & miserable people
Everywhere!

GREGCERY issued a memo on it.
Whereupon the entire contents
of the Steno Pool
Identified with it STRENUOUSLY,
And WORSHIPPED IT as a WAY OF LIFE,
And took their little Pills by it.
And went back 'n forth from
work by it.
And paid their rent by it,
And before long they were even
having
BIRTHDAY PARTIES IN THE OFFICE
by it,
Because NOW. AT LAST,
CRECGERY PECCARY's exciting new

invention
Had made it possible
For everyone
To find out
HOW OLD THEY WERE!

What hath GOD wrought?

Unfortunately,
There were some people
Who simply DID NOT WISH TO KNOW
---
Best wishes Harald

"peter" skrev i melding
...
Hi,
I just tried using a userform with a calendar control that works with

excel 2002 on a machine with excel 2003. It didn't work. What files need to
be in whcih folders to get a calendar control for excel 2003?

peter




  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 29
Default calendar userform

Hi,
Thanks for the info. Does that mean that if I am running office prof which comes with Access and the control IS available, and the other pc is running office small business ( no MS access) and the control is NOT available, that there is no way to make it available on that pc without installing MS access?

peter

"Harald Staff" wrote:

Hi Peter

I think it's either mscal.ocx (installed with Access and downloadable from
the web, do a Google search) or a licensed mscomct2.ocx (installed and
licensed with Visual Studio).

Allow me to spend some room for some cool lyrics by one of the finest
american composers:

SUNDAY

Sunday?
WOW!
SUNDAY,
'MONDAY

SUNDAY,

SATURDAY. . .TUESDAY THROUGH
- MONDAY'!

SATURDAY. . .

And thus THE CALENDAR,
In all of its colorful disguises
Was presented to
The bored & miserable people
Everywhere!

GREGCERY issued a memo on it.
Whereupon the entire contents
of the Steno Pool
Identified with it STRENUOUSLY,
And WORSHIPPED IT as a WAY OF LIFE,
And took their little Pills by it.
And went back 'n forth from
work by it.
And paid their rent by it,
And before long they were even
having
BIRTHDAY PARTIES IN THE OFFICE
by it,
Because NOW. AT LAST,
CRECGERY PECCARY's exciting new

invention
Had made it possible
For everyone
To find out
HOW OLD THEY WERE!

What hath GOD wrought?

Unfortunately,
There were some people
Who simply DID NOT WISH TO KNOW
---
Best wishes Harald

"peter" skrev i melding
...
Hi,
I just tried using a userform with a calendar control that works with

excel 2002 on a machine with excel 2003. It didn't work. What files need to
be in whcih folders to get a calendar control for excel 2003?

peter





  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,327
Default calendar userform

Hi Peter

If we talk the Access mscal.ocx, it's legal, free and not too complicated.
Here is a good place to get it (I think, didn't actually run it from here
since I have both Access and Visual Studio):
http://www.fontstuff.com/mailbag/qvba01.htm
or this MS site (it looks very old)
http://www.microsoft.com/officedev/tips/regactx.htm

HTH.Best wishes Harald

"peter" skrev i melding
...
Hi,
Thanks for the info. Does that mean that if I am running office prof

which comes with Access and the control IS available, and the other pc is
running office small business ( no MS access) and the control is NOT
available, that there is no way to make it available on that pc without
installing MS access?

peter



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
Enter date in userform using Calendar Control Scotty9349 Excel Discussion (Misc queries) 1 March 4th 09 07:02 PM
Calendar in UserForm cogent Excel Programming 4 May 14th 04 02:01 AM
UserForm | Incorporate a calendar cogent Excel Programming 3 April 27th 04 07:36 AM
How to use Microsoft Calendar Control 9.0 on a Userform Anupam Sharma Excel Programming 4 August 27th 03 06:19 PM
Calendar in UserForm Soniya Excel Programming 2 August 27th 03 05:24 PM


All times are GMT +1. The time now is 01:04 AM.

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"