Tip 2241: Locate Multiple Intersections Locate Multiple Intersections by Vinayan Parameswaran is a VBA program that will locate all the intersection points of multiple entities. The intersection points then are marked with a point object that is colored green. To run this tip, load the VBA program using VBAMAN, then start the macro Inter_with_multiple. You will be asked to select objects for intersections to be located. The rest is automatic. The program loops through the objects selected and finds all intersections between the objects. These intersection points are then marked with a point object that can be viewed by setting the PDMode system variable to a non-zero value (my personal favorite is to use mode 3, X marks the spot). This program is a nice example that shows how to manipulate objects in VBA and exposes some of the powerful methods available to object-level programmers. |