Growing VBA knowledge

[chopper_jc]

Hi All,

I have been VBA’ing for a few years now and although I can confidently approach most business problems, I still feel like im lacking the basics.

E.g. best approach methods, how to store modules, what methods run quicker than others etc.

Can anyone suggest any sources of information?

Thanks

 

[Andrew Fergus]

Hi

This subject comes up occasionally here at MrExcel. If you search the Excel forum and/or the Lounge you will find a few threads relating to speed etc. Nate Oliver and Tushar Mehta have some interesting opinions on this subject.

Rather than micro-managing aspects of your code to get the most speed gains, often the largest gains can be achieved by looking at what it is you are trying to achieve. By focusing on the desired outputs you should be able to accurately describe your inputs and from there design the most expedient process to get from one position to the other. This is where most gains are made.

But if you want to get into specifics about micro-managing your code, one area that often causes problems is string handling. There are some useful tips about string handling here but as I mentioned earlier there's no point optimising a routine that is either a) doing the wrong thing or b) that is not needed. But it is still important, IMHO, to learn good techniques to avoid writing unnecessarily slow code!

Just my opinion....
Andrew

 

[chopper_jc]

Thanks I will look up the threads and I will refer to the link on detail


what is the deal with MVP, is this a route worth exploring, in your opinion?


JC