• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 218
  • Last Modified:

VBA Classes to use

Hi Dave,

With reference to a previous question, I want to know how to do an event or change based on a change to ANY control, without having to create a function/subroutine STUB for each control as we have done in this workbook.  As you indicated - "When you're ready, ask that question as there are classes that can be developed that check for clicks all in one set of code."
Creating on-click codes for al types of buttons really adds up necessarily code lines.

Thank You
R
0
Rayne
Asked:
Rayne
  • 6
  • 3
  • 2
2 Solutions
 
GrahamSkanCommented:
What previous question did you intend to reference?
0
 
als315Commented:
0
 
RayneAuthor Commented:
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
RayneAuthor Commented:
I ended up using codes for individual controls like buttons. But there could be a single event handling class  in vba that would take care of all user inputs  as Demille indicated in the previous solution..
0
 
RayneAuthor Commented:
Any ideas?
0
 
als315Commented:
Did you try my example? You can insert your controls into Group box and have one event for all controls inside this box
0
 
RayneAuthor Commented:
Hello Als315,

Can you demonstrate that in this file? I see you insert _grp module but can you show how you include different controls types into that? Just an example..
0
 
als315Commented:
Strange answer was accepted :)
You can create group control and place your controls inside this group. Then you will be able to use one event for all controls inside this group.
0
 
RayneAuthor Commented:
Damn...I am sorry..I think I hit the wrong button...but anyways thanks to both Sir Graham and you :)
0
 
GrahamSkanCommented:
You can use the 'Request Attention' link to ask that the question be re-opened so that youcan re-assign the points.
0
 
RayneAuthor Commented:
Sure I will do that
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

  • 6
  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now