Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Leon Hansen   on Dec 14 In MS Office Category.

  
Question Answered By: Hababah Younis   on Dec 14

> 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..
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.

Share: 

 

This Question has 7 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on Simple Macro to Format All Sheets in a Workbook? Or get search suggestion and latest updates.


Tagged: