Intellisense for Parameters in VBA?

[kestefon]

Is there any way to activate Intellisense such that it only shows relevant parameter values?

For instance, if I write the following, I'd like to know what the possible values are for the parameter "CopyOrigin". Nothing pops up by default, but if I press Ctrl+J a long drop-down list will appear. This is somewhat useful, but the vast majority of values in the drop-down list are irrelevant/invalid for this parameter.

Please Login or Register  to view this content.

I've also attached a screenshot for your reference.
IntellisenseQuestion.png

[AB33]

I think Intellisense works with properties and methods of an object. If you tell VBA you have an object, it will help you with its methods and properties.

[kestefon]

Hmm...if that's the case, do you know how I would find out the relevant values for (for example) the "CopyOrigin" parameter? When I press F1 and go to Microsoft's documentation, it just provides a description.

[shg]

Excel's help has gotten appallingly worse with every release since 2003.

The best you can do, other than Google, is to use the object browser. If you guess to enter the word origin in the search box (maybe on your third try), you see enumeration XlInsertFormatOrigin with two members, xlFormatFromLeftOrAbove and xlFormatFromRightOrBelow.

[kestefon]

Thanks. Any idea if there's a systematic way to find the values for a parameter? Even a reference document listing the acceptable values for parameters would be useful. Otherwise you just have to constantly guess and pray that someone on the internet has already figured it out.

[shg]

If I had a systematic way, I'd have shared it with you.