Info

Figure 10.7

Use Auto List Members to allow the VBE to show you a list of possible property settings.

Figure 10.7

Use Auto List Members to allow the VBE to show you a list of possible property settings.

With this setting enabled, the VBE automatically displays a list that contains information that would logically complete the statement at the current insertion point. This happens as you are typing. All you need to do is select an item from the list and it is put in place in the code. In Figure 10.8, I typed Cht.ChartType =. Excel pops up a window with the possible constants. It is far easier to select xlLineMarkers from the list, as shown in Figure 10.8, than to try to remember the proper name for a particular type of chart.

Figure 10.8

If your object variables are properly declared, the VBE pops up a list of valid values as you type.

Figure 10.8

If your object variables are properly declared, the VBE pops up a list of valid values as you type.

^ CAUTION

If the Auto List Members ever suddenly stops working,you may have inadvertently introduced a compile error into your code. From the VBE menu, select Debug, Compile VBA Project to identify the problem.After you solve the compile error,the Auto List Members begins working again.

0 0

Post a comment