The information in this article applies to:
SYMPTOMSWhen typing code for the PivotTable object, the CommandText property is not available in the Microsoft Visual Basic for Applications auto list. STATUSMicrosoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. MORE INFORMATION
By default, Visual Basic for Applications provides the option to show members of objects that are contained within its libraries. For example, when you type an object name in a module sheet and press PERIOD (.), Visual Basic displays a list of members (properties or methods) for that object. REFERENCESFor more information about the CommandText property, in the Visual Basic Editor, click
Microsoft Visual Basic Help on the Help menu, type "CommandText Property" in
the Office Assistant or the Answer Wizard, and then click Search to
view the topic. Additional query words: OFF2000 XL2000 pivot table
Keywords : kbprg kbdta xlvbainfo xlpivot |
Last Reviewed: July 6, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |