Increase Your Productivity and Deliverables with Coding Tools for Microsoft Office, Visual Basic for Applications (VBA), and Visual Basic (VB6)

Why Total Visual CodeTools Exists

We at FMS developed Total Visual CodeTools to address the challenges we experienced in our own efforts to create great VB6 and VBA applications. From writing new code, to taking over someone else's work (or work we wrote years ago that looks like someone else wrote it), Total Visual CodeTools automates many of the steps to make you more productive.

Leveraging our technology to parse VBA/VB6 code, Total Visual CodeTools not only creates new code but updates existing code in powerful ways. It lets you apply Best Practices to your projects and standardize existing solutions.

The result is your ability to deliver more professional solutions, quicker than ever, in ways that would be nearly impossible to do manually. Discover why so many developers and teams insist on using Total Visual CodeTools to establish quality directly into their processes.

Professional Coding Utilities

Total Visual CodeTools supports all VBA/VB6 hosts, including Visual Basic 6.0 (VB6) and Microsoft Office (including Microsoft Access, Excel, Outlook, PowerPoint, Word, etc.). Loaded directly into the Integrated Development Environment (IDE), Total Visual CodeTools gives you a rich set of coding tools to increase your productivity and make your entire development team more effective.

Total Visual CodeTools makes it easy to:

  • Write solid code
  • Reduce the drudgery of common tasks
  • Clean up inherited code and standardize existing code
  • Rename variables to your naming convention
  • Create maintainable code
  • Find unused variables, constants, classes, user defined types, etc.
  • Add sophisticated error handling and line numbering to pinpoint crashes
  • Deliver code that is more difficult to decipher if you want to obfuscate it

The tools are available directly in your module editor from the menu or a dockable toolbar:

Module Coding Tools available as a toolbar from the IDE

Code Cleanup: Format and Standardize VBA/VB6 Code

Address issues that come with inherited code by applying consistent line formatting and indentations, custom error handling to procedures that lack it, renaming variables to your naming convention (e.g. all integers start with int, strings with str, etc.), and much more.

Sample VBA/VB6 Code Formatting and Standardization

Microsoft AccessShipping for Access 2013 and 2010

New Features:

  • Supports Office/Access 2010, 2013 and 2016 (32-bit version)
  • Code parser supports 32 & 64-bit VBA syntax
  • Code Cleanup and Delivery are faster with Apply Changes option
  • Copy Control Builder supports multiple controls
  • Long Text/SQL Builder supports query retrieval, converts tabs and spaces
  • Select Case Builder supports text blocks and numeric ranges
  • Recordset Builder defaults to current database and simplifies selections
  • Message Box Builder enhanced
  • 3 Locations for Total Visual CodeTools on your menus
  • Screens are resizable
  • Redesigned storage of Standards and improved international support
  • New help file and user manual
  • all the new features...

Total Visual CodeTool's Menu Integrated Directly in Your VB6 and VBA/Office IDE MenuCode Delivery: Add Line Numbers and Obfuscate VBA/VB6 Code

Before distribution, easily add line numbers to all of your code so you can take advantage of VB6/VBA's ability to pinpoint the exact line where an error occurs. You can also obfuscate your code for situations where you need to distribute your source code, but are concerned about its misuse.

Sample VBA/VB6 Code Line Numbering and Obfuscation

Code Builders: Simplify Coding Chores

Simplify the development process and ensure that new code follows your organization's standards for naming, commenting, error handling, and more:

  • New Procedure Builder to create procedures with your custom commenting and error handling structure while automatically referencing the module and procedure names
  • Recordset Builder to create DAO and/or ADO code to browse, add or edit a record from tables and queries
  • Long Text Builder to convert SQL strings from a query to code while handling issues such as quotes and smart word-wrapping based on line length and SQL words (like WHERE, JOIN, etc.).
  • Message Box Builder to visually use the MsgBox command and its results
  • Select Case Builder to easily create SELECT CASE statements
  • Copy Control Builder to easily copy all the events of one control to another control in the same form/object or another one
  • New Property Builder to easily create Let, Get, and Set statements with your custom commenting and error handling structure, along with the declaration level property variable
  • Format Builder to easily use the Format command to manage strings, numbers, currency and dates
  • Date Difference Builder to easily use the DateDiff builder to compare two dates

Take the Builders Tour for more details on each builder.

Additional Coding Tools

There are many other powerful tools to ease the development process:

  • Unused Variable Analysis analyzes your entire project to find unused variables, constants, classes, user defined types, and elements
  • Macro Recorder to record and reply keystrokes to simplify the repetition of a complex set of tasks
  • Code Commenter that comments and uncomment blocks of code with advanced features
  • VBE Color Scheme manager to easily see and set colors for your editor
  • Close Code Windows to close all open windows (for VB6 it handle objects and code separately)
  • Clear Immediate Window

Total Visual CodeTools Improves Quality and Reduces Costs

We're so confident in this product's power, we guarantee that it will save time and money in the first week of use. If not, return it for a prompt and courteous refund within 30 days.

Download Trial of Total Visual CodeTools for VB6 and VBA/Office/Access Download the trial version to see how it can work for you.

Total Visual CodeTools Pricing
for Visual Basic (VB6) and VBA such as Microsoft Office/Access/Excel/Word
Licenses Price 2016, 2013, 2010, 2007,
2003, 2002, 2000, VB6
97
Single $299 Buy Now Buy Now
5-Pack $899 Buy Now Buy Now

Upgrades

Single $199 Buy Now Buy Now
5-Pack $899 Buy Now Buy Now

Premium Support Subscription

Single $299 More Information
5-Pack $999

Also Available as part of:

Runtime/Redistributable Version

Not Applicable

Licensing Information

Total Visual CodeTools is licensed on a per developer basis.
Each developer who uses the program must have a license.

Total Visual CodeTools User manual

Microsoft Office Access 2016, 2013, 2010 Version
is Shipping

New Features

Supports Office/Access 2016, 2013, 2010, 2007, 2003, 2002, 2000, and Visual Basic 6.0!

Also available for
Access 97


View all FMS products for Microsoft Access All Our Microsoft Access Products

Rave Reviews

"Total Visual CodeTools is by far my favorite third-party product."

Alison Balter, Author, Conference Speaker, Instructor


Best Visual Basic Add-In
Rave Reviews

CodeTools Info

Why CodeTools?

Additional Info

 

 

Free Product Catalog from FMS