AET VBE Tools v1.7

Finally they're ready!

What's new?

1. Rename Userform Controls
This tool allows you to batch rename all controls on a userform via a simple Find and Replace interface. In addition to changing the control names, it also changes code with the old control name to the new control name.

So, if you want to change all controls that start with "CommandButton" to "btn" or "cb", etc, this is the way to do it all at the same time!



2. Make Project Variables List
The bigger the project, the more complex it becomes.

This tool analyses your code and makes a list of variables and constants.



Details include:

Module Name (Where the variable or constant is)

Scope (Public, Private, Type or Procedure)

Location (Declaration or procedure name)

Name (Variable or constant name)

Type (Variable or constant type, eg String, Long, etc)

Const (True or null, to discern between variables and constants)

Const Value (Value if constant)

Found in Project (Count within project)

Found in Report (Count within report)

Modules Count

Procedures Count

Unique Values

Duplicate Values

More features are planned in the near future.

3. Copy Code for Web
If you need to show your code on the web, normal indenting won't show. The way to get around it is to convert indent spaces to " ".

This tool does that and copies the code to the clipboard so you can paste it where required.

4. Delete Orphan Code
This feature was added at the request of Kellsens Willamos, who has supported me and the development of these tools from the beginning.

What's "orphan code"?

When developing, did you ever click userform controls by mistake? Maybe you get something like this.

Private Sub lblSelectProject_Click()

End Sub

Chances are you don't want the code, and if there's nothing between the first and last line, it's a fair bet that you don't. The Delete Orphan Code tool looks for code like this and gets rid of it.

I've added it as an option on Cleanup Project Code. To include it, tick the checkbox on the Settings form.



AET VBE Tools are no longer free. But I'm keeping the price low so they are affordable. (And you will get future versions free of charge!)

You can download them here.

P.S. Tick the G+1 icon at the bottom of my post to tell me if you like what you see!