Thursday, 21 August 2014
New Starter to VBA
If you are a new starter in VBA programming I have to say you need to plan your programming before start writing down any code. Obviously what matters is to write down a set of procedures and functions just to facilitate your day to day Microsoft Excel calculation and analysis. But it would be beneficial to plan your coding in a way that you'll to be able to reuse your functions and procedures in different excel workbook with minimum adjustment to your code. Therefore it would be best to think and plan out what your procedure suppose to do to generate a set of results or execute a set of procedures regardless of the position of your input data. I've been suggesting everyone who asks for my help to broke down your code into smaller functions and procedures and recall them when you need. That would help to pass the input data as scope variables and hence increase the flexibility of your code. so FUNCTIONS!! FUNCTIONS!! FUNCTIONS!! plan out your code and break it down in to FUNCTIONS.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment