XL2000: Auto List Does Not List CommandText for PivotTable Object (201455)


The information in this article applies to:

  • Microsoft Excel 2000
This article was previously published under Q201455

SYMPTOMS

When typing code for the PivotTable object, the CommandText property is not available in the Microsoft Visual Basic for Applications auto list.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are 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.

The CommandText Property returns or sets the command string for the specified object and does not appear in the auto list as a member for the PivotTable object.

REFERENCES

For 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.
Modification Type:MinorLast Reviewed:10/10/2006
Keywords:kbbug kbpending kbProgramming KB201455
©2004 Microsoft Corporation. All rights reserved.