Chip,

You guys sure do a good job, quick and concise. I try to help where i can but most of the time i am still the one asking the questions.

Keep Up The good work

"Chip Pearson" wrote:

For properties, you use Property Get, Property Let, and Property
Set. E.g.,

Private pPropName As Long

Public Property Get PropName() As Long
PropName = pPropName
End Property

Public Property Let PropName(Value As Long)
pPropName = Value
End Property

Property Set is used for object type properties.

Just out of curiosity do Mvp's Get paid to answers Posts ?

Nope, we're all volunteers, end users like yourself. We just like
helping others by answering posts.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com






"WStoreyII" wrote in
message
...
Chip,

Properties are really different to how do you use those?

Just out of curiosity do Mvp's Get paid to answers Posts ?
Becuase any newsgroup that i post a question in, i always get
reply from mvps and really quick as if they were sitting there
waiting for the question?

WStoreyII

Thanks Alot

"Chip Pearson" wrote:

In VBA, you don't enclose argument to Sub procedures in
parentheses. Only arguments to Function procedures are
enclosed
in parens. Change
I.Add(True,10)
to
I.Add True,10


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com