|
[x]
Posted via EE Mobile
|
|
| Search, ask, and monitor your questions on the go with EE Mobile. Visit Experts Exchange from your mobile device and never be out of touch again. |
|
|
|
|
|
[x]
The Solution Rating System
|
|
| With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating. - The Grade of the Solution
- The Zone Rank of the Expert Providing the Solution
- The Number of Author and Expert Comments
- The Number of Experts Contributing
- The Feedback of the Community
Your Input Matters
Because of the way the system is set up, the most important variable in this equation is you. As a member of Experts Exchange, you are able to cast your vote on the quality of the solutions in regard to how complete, accurate, helpful and easy to understand each solution is. When you provide your feedback, each rating is adjusted accordingly. So, if you see a solution that has a poor rating that you think is a good solution, let us know by rating it. As you do, the rating will be adjusted and will become more accurate for other members of our site. If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support. Thank you! |
|
|
|
|
Asked by shacho in Microsoft Excel Spreadsheet Software, Microsoft Access Database, Outlook Groupware Software
I have been programming Office applications with VBA for several years now and have read many books on the subject. One thing I have never quite been able to grasp is when and why to use custom events. Events for application objects make sense because they can start code execution with parameters when the the application is not already executing code. But in order for custom events to fire, code has to be already executing as a result of some other trigger. So what is the purpose of doing the extra coding just to make something an event plus handler, instead of an ordinary subroutine that passes parameters around? In fact, it seems that if you do use events and handlers, you're actually making the call chain harder to follow in the code. For example, one book provided an example where a user form has a public WithEvents object variable that is used to instantiate a text file class. The text file class has an OpenFile routine that accesses the text file reads it line by line. Each time a line is read, the ReadLine event fires. The listener then shifts execution back to the user form to handle MyTextFile_ReadLine(LineTe
xt as String), which drops the line into a textbox and inserts a carriage return. Why would this make more sense than just having a public FileText Property in the class or a GetText Procedure?
Mike
20091118-EE-VQP-93 - Hierarchy / EE_QW_EXPERT_20070906
