> 1. What are the other items in the Excel Collection(s)? Where can I
> find a list of such things, so I know what I can refer to and
> what its proper name is?
Try gooling for the object model. If you can get a pictorial representation
that's great. The object model shows what is connected to what and gives
great clues as to how to reference things. Also... In the VBE you could try
having a look at the object browser but it's a bit daunting at first if you
don't know what your looking at!
> How was I to know that worksheet
> objects are called "Sheets" and not "Worksheets" or "Tabs"?
Object model... Sample code... Excel VBA Help... Ask here!!!
You could also try the techtrax site for tutorials and info :-)
> 3. I notice that when I record a macro, and in the code you sent me,
> the whole thing is called a "sub". I imagine that's what
> makes it callable by name from other macros. What's a
> "procedure" and how do procedures relate to macros and subs?
"Macro" is really a misnomer and comes from... IMHO,, (Again!! This could
get boring!!) the dark ages of Excel and other programs.
Subs are Procedures. It's that simple. So are functions. The difference is
that Subs don't return a value.
Procedures are just lines of code to do things... Pick up that.. Do this...
Do that..
A simple sub to beep would be..
Sub soundbeep
Beep
End Sub
You would make it happen in your code by writing
Soundbeep
If you wanted to return a value... Like setting a date format for example,
you'd use a function... Which remember is still a procedure.. Just a
different type.. One that returns ummm .. Values
Sub is from subroutine I think.
> 4. How is "method" defined, and where can I find a list of the
> methods available in Excel VBA? Is a method a kind of verb
> that acts on an object, which is analogous to a noun? How can
> I find the syntactical requirements for methods, and for that
> matter, what they do)?
Methods... Well!!!!
There are, very basically 2 dinguses that an object may have...
Properties... And Methods.
Methods do things.... Examples are .Delete .Add .Hide .Load and so
on.
Properties are values describing status.
If you use the .Hide method for example then there is a .Visible property
that changes to False.
To find out what properties/methods an object has you have to look at the
documentation in the help. Having said that... There is a lot of information
that pops up when you type a dot "." after an objects name.