Solved

VBA Classes to use

Posted on 2012-04-12
12
205 Views
Last Modified: 2012-04-14
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
Comment
Question by:Rayne
  • 6
  • 3
  • 2
12 Comments
 
LVL 76

Expert Comment

by:GrahamSkan
ID: 37841430
What previous question did you intend to reference?
0
 
LVL 39

Expert Comment

by:als315
ID: 37841497
0
 

Author Comment

by:Rayne
ID: 37843320
0
 

Author Comment

by:Rayne
ID: 37843331
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
 

Author Comment

by:Rayne
ID: 37845242
Any ideas?
0
How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

 
LVL 39

Expert Comment

by:als315
ID: 37845632
Did you try my example? You can insert your controls into Group box and have one event for all controls inside this box
0
 

Author Comment

by:Rayne
ID: 37845662
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
 
LVL 39

Accepted Solution

by:
als315 earned 400 total points
ID: 37845860
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
 

Author Comment

by:Rayne
ID: 37845884
Damn...I am sorry..I think I hit the wrong button...but anyways thanks to both Sir Graham and you :)
0
 
LVL 76

Assisted Solution

by:GrahamSkan
GrahamSkan earned 100 total points
ID: 37846420
You can use the 'Request Attention' link to ask that the question be re-opened so that youcan re-assign the points.
0
 

Author Comment

by:Rayne
ID: 37846780
Sure I will do that
0

Featured Post

Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

Join & Write a Comment

Suggested Solutions

Introduction This Article briefly covers methods of calculating the NPV and IRR variants in Excel as well as the limitations in calculating and interpreting IRR results. Paraphrasing Richard Shockley, author of my favourite finance reference tex…
PaperPort has a feature called the "Send To Bar". It provides a convenient, drag-and-drop interface for using other installed software, such as Microsoft Office. However, this article shows that the latest Office 2016 apps (installed with an Office …
Learn how to make your own table of contents in Microsoft Word using paragraph styles and the automatic table of contents tool. We'll be using the paragraph styles in Word’s Home toolbar to help you create a table of contents. Type out your initial …
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.

760 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now