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