XL97: Copy From Object Browser May Not Copy Named Arguments (157315)
The information in this article applies to:
- Microsoft Excel 97 for Windows
This article was previously published under Q157315 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.
WORKAROUNDWorkaround 1
You can copy named arguments from the Object Browser. To do this, follow
these steps:
- Select the text of the item and its named arguments in the Detail
section and then click Copy on the Edit menu.
- Go to the location where you would like to paste the named arguments,
and then click Paste on the Edit menu.
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:
- On the Tools menu, click Options.
- Click the Editor tab.
- 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
click the Display button and then double-click the topic "Use the Object
Browser".
| Modification Type: | Minor | Last Reviewed: | 10/11/2006 |
|---|
| Keywords: | kbdtacode kbprb kbProgramming KB157315 |
|---|
|