Bookmark page
Printable version
Course updatesForum home » Delegate support and help forum » Microsoft Excel VBA Training and help » VBA
|
|
|
Bookmark this page|
The UK's most regular Training information: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
VBA
Resolved · Low Priority · Version 2003
Reply
VBA
Do you have a recommended best practice for an overall structure / approach to coding in VBA. (E.g. The key steps to take when approaching a coding project)For upcoming training course dates see: Pricing & availability
RE: VBA
Hi AndrewThanks for your question
This is a massive subject in its own right. Whole books have been written on the subject.
I would suggest the following as a general approach
1. Id the outputs that you require. What data do you need to show
2. Id the inputs, what data will youi start with.
3. List the steps and analysis required to turn your inputs into outputs
4 Break the steps in three above, into a set of discreet operastions and then write the code
5. Finish by building interfaces for your users and formatting tghe data output
Regards
Stephen
|
