Awards
Join OfficeTipsAndMethods

Have some suggestions to share with the world?

Join OfficeTipsAndMethods and share your insight in a Comment. You must be a member to comment and all comments are moderated before being published. Membership is free and we would never share your personal information with anyone.

Become an OTM Member

Log In

YouTube Video Channel
OfficeFix
Article Categories

Archive for the ‘VBA’ Category

Tools for the VBA Developer

Thomas Möller of Team-Moeller has very kindly given permission to publish this commented  list of VBA development tools.

 

Tool-Name: TM VBA-Inspector

Author: Thomas Möller

URL: http://www.team-moeller.de/en/?Add-Ins:TM_VBA-Inspector

Purpose: Examine VBA-Code to find hidden faults and bad coding styles

 

Add. Info: For additional information refer to the help file and

this post on the Access Team Blog:

http://blogs.office.com/b/microsoft-access/archive/2010/09/30/enhance-the-quality-of-your-vba-code.aspx

 

 Tool-Name: MZ-Tools 3.0 for VBA

Author: Carlos J. Quintero

URL: http://www.mztools.com/v3/download.aspx

Purpose: Great number of functions to make coding easier

 

Add. Info: You can attach a function to a shortcut

Options dialog / Shortcuts / Add "Search" to CTRL+F

 

Add. Info: You can easily rename a variable or a procedure:

  • Double click in variable name

  • Start Find-Dialog (CTRL + F) / Start search

  • Insert new name

  • Select each item and hit "Replace"

Tool-Name: VBE Tools v2.0

Author: Office Automation Ltd

URL: http://www.oaltd.co.uk/VBETools/Default.htm

Purpose: Bigger ‘Location’ label in References dialog

 

Add. Info: Start the options dialog. Check "Resize ‘Location Label’

on Tools / References dialog"

 

Tool-Name: Smart Indenter v3.5

Author: Office Automation Ltd

URL: http://www.oaltd.co.uk/Indenter/Default.htm

Purpose: Indent the whole code in a procedure, in a module or

in the whole project with one mouse click

 

Add. Info: Have a look at the options dialog. It shows directly

how the chosen options will indent your VBA-Code

 

 Tool-Name: TM VBA-ToDoFinder

Author: Thomas Möller

URL: http://www.team-moeller.de/?Add-Ins:TM_VBA-ToDoFinder

Purpose: Find ToDo’s in your VBA-Code

 

Add. Info: Tool and website is available only in German language

(But there is less UI – so check it out)

 

Add. Info: Put your ToDo’s as a comment to your VBA-Code

For example: ‘ToDo: Optimize this loop

Start ToDo-Finder and hit the Refresh-Button

 

 

 Tool-Name: Procbrowser

Author: Sascha Trowitzsch

URL:

http://www.mosstools.de/index.php?option=com_content&view=article&id=58:procbrowser&catid=34:accesstools

Purpose: Browse through the procedures of a code-module

 

Add. Info: You find the button for download at the end of the website

 

Add. Info: Start the tool: Add-Ins / Procbrowser

Change the language: Context menu / "Sprache" / "Englisch"

John R. Durant’s WebLog : Why VBA Still Makes Sense

This article, John R. Durant’s WebLog : Why VBA Still Makes Sense , presents a solid case  for why VBA is the ‘next level’ when it comes to application development in Access and other members of the Office suite. John provides an excellent of VBA since its early days to the present and on into Office 2010 including his perspective on the ‘fit’ between .NET and VBA. John R. Durant’s WebLog : Why VBA Still Makes Sense is definitely a worthwhile read.