XL97: Copy From Object Browser May Not Copy Named Arguments

 Last reviewed: February 27, 1998
Article ID: Q157315
The information in this article applies to:

- Microsoft Excel 97 for Windows

SYMPTOMS

In the Visual Basic Editor for Microsoft Excel 97, named arguments are not copied when you copy a property, method or function in the Object Browser.

NOTE: This behavior differs from the functionality of the Object Browser in earlier versions of Microsoft Excel.

CAUSE

When an item in the Object Browser's Member pane is selected, only the name of the item is copied to the clipboard.

WORKAROUNDS

Workaround 1

You can copy named arguments from the Object Browser. To do this, highlight the text of the item and its named arguments in the Detail section and then click the Copy button.

Workaround 2

You can use the "Auto Quick Info" feature of the Visual Basic Editor to display information about functions and their parameters as you type.

To enable "Auto Quick Info" do the following:

  1. On the Tools menu, click Options.

  2. Click the Editor tab.

  3. Select "Auto Quick Info" and click OK.

When this feature is enabled and you type a function in the Code Window, a small information window appears beneath your line of code that indicates the syntax of the function you're typing.

STATUS

This is by design of the Object Browser included with Microsoft Excel 97.

REFERENCES

For more information about using the Object Browser, click the Index tab in Visual Basic for Applications Help, type the following text 

   Object Browser
click the Display button and then double-click the topic "Use the Object Browser".

Additional query words: XL97 8.0 8.00 parameter
Keywords : kbprg xlvbahowto xlvbainfo
Version : WINDOWS:97
Platform : WINDOWS

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: February 27, 1998
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.