Part 1: Overview of the VBA Utility

Tutorial Navigation | Previous: Tutorial: VBA to C# Add-in | Next: Part 2: Adding the VBA Utility to ArcMap

The VBA utility used in this conversion tutorial was developed to solve a specific problem: how to quickly view the extent of each line feature in a group of overlapping line features that fall on the same geographic line. In the sample map below there are actually 13 overlapping line features. Only portions of 5 of 13 features are visible.

Click here to see a short video of the Stagger Offset VBA Utility in action.
(duration 1:02, the video will run in a new browser tab or window)

Sample Map with overlapping line features

Each feature represents a segment of highway that is the subject of a specific project. Often several detail maps must be created to adequately display the projects related to the particular highway. In order to set the extent of each detail map it is important to see the start and end of each project.

The VBA utility stagger offsets the line features by a user-entered amount. It is launched from a toolbar button, provides a simple dialog, and runs in an edit session for easy undo/redo.

Sample Map with overlapping line features

Sample Map with overlapping line features

Tutorial Navigation | Previous: Tutorial: VBA to C# Add-in | Next: Part 2: Adding the VBA Utility to ArcMap

  1. No comments yet.
(will not be published)