Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
A taxonomy of methods and properties
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! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
A taxonomy of methods and properties
Wow. VBA is a lot more complicated than I suspected. It could take
some familiarization to navigate. Is there a website that explains how all the fields and panes relate to each other? On May 11, 12:05*pm, Dave Peterson wrote: 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 athttp://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). |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
A taxonomy of methods and properties
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Available methods and properties through OLE interface | Excel Discussion (Misc queries) | |||
Hidden workbook properties/methods | Excel Programming | |||
HELP! Object, Properties & Methods | Excel Programming | |||
Ctrl-J list of properties and methods | Excel Programming | |||
VBA Editor not showing list of properties & methods | Excel Programming |