View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
mike mike is offline
external usenet poster
 
Posts: 216
Default reading statements

Thanks!
-----Original Message-----

-----Original Message-----
how do you read statements?? i know you are to read

right
to left.
Is it 'property.method.value'
is that how it is set up..what follows the period and

so
on?
THANKS!

where can i go to read up on the breaking down of the
statements to understand what it is asking?
.


It is not so straightforward. You read left to right.
The first item on the left is the object you are

referring
to (i.e. Worksheet, Range, etc.). After the period

comes
one of the object's properties OR methods, or a child
object (for example, a Worksheet object contains any
number of Range objects). There can be many levels of
these steps, each separated by the period.

Any intoductory book on VBA or Visual Basic would be a
help; I also recommend you learn about the object

browser
in the VBA interface, since it can help you see all the
objects, properties and methods of the application you

are
working with.
.