View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default A taxonomy of methods and properties

VBA's help is very nice.

Say you want to find out about Ranges.

type this:
dim aa as Range
Put the cursor in the word "Range" and hit F1

Then select:
Range property as it applies to the Application, Range, and Worksheet objects.

Then click on the Range link in this sentence:
Returns a Range object that represents a cell or a range of cells.

You'll see properties and methods that apply to the Range object.

Methods are like verbs (that do something and Properties are like adjectives
(that describe a feature of that object).

You can also use the Object Browser within the VBE.
Open the VBE
Hit F2
Search for Range

And you'll see lots of info.

wrote:

I'm spinning up on VBA/Excel at
http://www.anthony-vba.kefra.com/vba/vbabasic2.htm.

Where can one find a navigatable tree of frequently used member
methods and properties, similar to what one might find for matlab
objects?

I suspect that a tree of frequently used members would be more useful
to a newbie than a comprehensive tree (correct me if I'm wrong).

Thanks!


--

Dave Peterson