XL2000: Copying from the Object Browser May Not Copy Named Arguments

ID: Q213786

The information in this article applies to:

Microsoft Excel 2000

SYMPTOMS

In the Microsoft Visual Basic Editor for Microsoft Excel 2000, 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 versions of Microsoft Excel prior to Excel 97.

CAUSE

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

WORKAROUND

Workaround 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 then 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.

REFERENCES

For more information about using the Object Browser, in the Visual Basic Editor, click Microsoft Visual Basic Help on the Help menu, type Object Browser in the Office Assistant or the Answer Wizard, and then click Search to view the topic.

Additional query words: parameter XL2000

Keywords : kbprg kbdta KbVBA
Version : WINDOWS:2000
Platform : WINDOWS
Issue type : kbprb