Writing the rule set

In Chapter 4 you learned how to write VBA code to add a rule set and rules, and, although you could repeat this throughout the rest of this chapter, I prefer to use the user interface that we developed in chapters 6 and 7. Therefore, you will need to install the Rules Tools add-in or run the Validation Explorer solution from Visual Studio 2010, in order to write the rules easily. However, I have included VBA methods to add (or update) the rule set and rules, which can be written into the VBA project of any Visio document, but should be run when the document that you want to add the rules to is active.

Open the Rules Explorer window from the Rules Tools group on the Process tab.

With your document node selected in the Rules Explorer window, click the Add button, then enter the Name, Name U, and Description of this new rule set.

You can now add each of the new rules by translating the previous descriptions into validation formulae.

The equivalent VBA code is listed below...