template vba code

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Access VBA Training and help » Template for VBA Code

Template for VBA Code

resolvedResolved · Medium Priority · Version 2003

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

 

Training courses

 

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
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Access tip:

Copy a Previous Record's Values to a New Record

If you often enter the same value in one field of a table, there are two methods to save re-typing the data.

1. Use Ctrl+' (apostrophe) to repeat the value input in the previous record.

2. Change the field's DefaultValue property in Design View to the most commonly used value.

View all Access hints and tips


Server loaded in 0.07 secs.