LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 102
Default Class module to access range events

I was wondering if anyone out there could help me to find a way to
create a class that essentially would be composed of 3 cells. I dont
know if this is possible as I have been at it for awhile. I know how
to create classes, and have some familiarity with the "With Events"
keyword, but am at a loss for how to get my class to respond to a
change that takes place within the specific cells within the class.
The reason I am looking into this is that I want to create a Bowling
Frame:
one cell will be the first ball
another cell will be the second ball (it's data validation will be
set to allow for only the pins remaining)
the last cell will contain the score.

I want to be able to update the score and the second ball cell
whenever an entry has been made.

I hope this is clear enough. Any help would be really
appreciated as I am tired of running into the same wall. If you need
any more information in order to help, please post and I will give it
to you ASAP.

Thanks,
Mark
 
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
XL2003: Is it possible to sink a form's events in a class module ? Michel S. Excel Programming 4 February 20th 07 09:04 AM
To access a previous object via class module Pierre Archambault Excel Programming 3 December 31st 05 06:51 AM
How to access group buttons in Class Module? Myles[_9_] Excel Programming 7 December 10th 05 02:37 PM
Reference Class Module in Access from Excel [email protected] Excel Programming 2 September 28th 05 09:55 AM
What events can be captured in a Class Module? Tom Ogilvy Excel Programming 4 September 8th 03 05:41 AM


All times are GMT +1. The time now is 12:34 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"