Vijay has attended:
Excel VBA Intro Intermediate course
Template for VBA Code
Hi Anthony,
As per our conversation on Friday afternoon, please can you investigate/advise as to whether there are any types of templates applicable to VBA, which can assist with the coding when creating any Projects?
Thanks,
Vijay
RE: Template for VBA Code
Hi Vijay, thanks for your query. A template for absolutely any VBA project is a tough call, but I remember us discussing tools to assist the coding process. This is an example of what I was talking about:
http://www.aivosto.com/index.html
There are freeware versions of this functionality out there. Essentially, it's a tool to help you better visualise the logic of your code, display it in a flowchart etc. Of course, even the sort of looping that we were doing will result in quite a complicated flow chart but it's this sort of tool you might want to investigate, particularly in the early stages of your coding development.
Hope this helps,
Anthony