Using a Watch on an Object

In the last example, we watched a specific property—Selection.Address. It is also possible to watch an object, such as Selection. In Figure 2.38, I have set up a Watch on Selection. I get the glasses icon and a + icon.

Figure 2.38

Setting a Watch on an object gives you a + icon next to the glasses.

Figure 2.38

Setting a Watch on an object gives you a + icon next to the glasses.

By clicking on the + icon, I can see all the properties associated with Selection. Look at Figure 2.39! You can now see more than you ever wanted to know about the Selection. There are properties that you probably never realized were available. You can see that the .Addlndent property is set to False and the .AllowEdit property is set to True. There are useful properties in the list—you can see the .Formula of the selection.

In this Watch window, some entries can be expanded. The Borders collection has a plus next to it. Click any + icon to see even more details.

Figure 2.39

Clicking the + icon shows a plethora of properties and their current values.

Figure 2.39

Clicking the + icon shows a plethora of properties and their current values.

0 0

Post a comment