?
Solved

VBA Classes to use

Posted on 2012-04-12
12
Medium Priority
?
213 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 6
  • 3
  • 2
12 Comments
 
LVL 76

Expert Comment

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

Expert Comment

by:als315
ID: 37841497
0
 

Author Comment

by:Rayne
ID: 37843320
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 

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
 
LVL 40

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 40

Accepted Solution

by:
als315 earned 1200 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 300 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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

How to get Spreadsheet Compare 2016 working with the 64 bit version of Office 2016
This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

771 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