Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
pk pk is offline
external usenet poster
 
Posts: 5
Default Class modules

Hello and thanks to everyone contributing to my
assistance. Especially Tom Ogilvy and KeepItCool.

I would like to build some customizations into the built-
in Microsoft Calendar control, to use repeatedly. I guess
this would/could be done in a class module?

Does anyone have any information on how to do this with
the calendar (specifically) as well as information and
learning materials (generally) regarding creating and
using your own classes? [Even if a class is inappropriate
for the calendar I would like to learn about classes]

I am very familiar with and fairly experienced with VBA,
but I know next to nothing about creating a class. I am
limited to VBA, currently using Excel XP for development.

Your advice and sources for info are greatly appreciated.
Thanks in advance.
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 8
Default Class modules

With inspiration from one of the Chapters
in Excel 2000 Power Programming written by John Walkenbach, I have
developed my own Calendar Class. The calendar looks and works much
the same way as Microsofts as far as I can see.

If you want a copy, let me know and I can send you a copy.

Best wishes
Jan


"pk" skrev i melding
...
Hello and thanks to everyone contributing to my
assistance. Especially Tom Ogilvy and KeepItCool.

I would like to build some customizations into the built-
in Microsoft Calendar control, to use repeatedly. I guess
this would/could be done in a class module?

Does anyone have any information on how to do this with
the calendar (specifically) as well as information and
learning materials (generally) regarding creating and
using your own classes? [Even if a class is inappropriate
for the calendar I would like to learn about classes]

I am very familiar with and fairly experienced with VBA,
but I know next to nothing about creating a class. I am
limited to VBA, currently using Excel XP for development.

Your advice and sources for info are greatly appreciated.
Thanks in advance.



  #3   Report Post  
Posted to microsoft.public.excel.programming
pk pk is offline
external usenet poster
 
Posts: 5
Default Class modules

Jan, I would be most interested in seeing your calendar
class. Please e-mail it to me at your earliest
convenience. Thanks much...

-----Original Message-----
With inspiration from one of the Chapters
in Excel 2000 Power Programming written by John

Walkenbach, I have
developed my own Calendar Class. The calendar looks and

works much
the same way as Microsofts as far as I can see.

If you want a copy, let me know and I can send you a

copy.

Best wishes
Jan


"pk" skrev i melding
...
Hello and thanks to everyone contributing to my
assistance. Especially Tom Ogilvy and KeepItCool.

I would like to build some customizations into the

built-
in Microsoft Calendar control, to use repeatedly. I

guess
this would/could be done in a class module?

Does anyone have any information on how to do this with
the calendar (specifically) as well as information and
learning materials (generally) regarding creating and
using your own classes? [Even if a class is

inappropriate
for the calendar I would like to learn about classes]

I am very familiar with and fairly experienced with

VBA,
but I know next to nothing about creating a class. I am
limited to VBA, currently using Excel XP for

development.

Your advice and sources for info are greatly

appreciated.
Thanks in advance.



.

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
Help with modules. Cloudy New Users to Excel 1 June 17th 08 10:10 AM
Naming class modules in Excel 2002 bryan Excel Discussion (Misc queries) 2 December 13th 04 11:42 AM
Class Modules vs Modules Jeff Marshall Excel Programming 2 September 28th 03 07:57 PM
Class Modules Siphuncle Excel Programming 2 August 12th 03 06:37 PM
Event - RaiseEvents Within Class Modules John Peterson[_3_] Excel Programming 4 July 17th 03 12:53 AM


All times are GMT +1. The time now is 05:36 AM.

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

About Us

"It's about Microsoft Excel"