Property Get, Property Let functions

[pkh]

Hi,

I am trying to understand Class objects and have the following question regarding Property Get and Property Let functions.

Functionally, it seems they are just assigning or obtaining values for the property variables. Why can't we just assign them directly as values to variables instead of putting them through the Property Get (or Let)........Property End code.

In the examples I have seen, for eg.

Private pName as String
 
Public Property Get Name () As String
       Name = pName
End Property
 
Public Property Let Name (Value As String)
        pName = Value
End Property
' these examples are from C Pearson's VBA lessons

Why not just use:

Private pName as String
 
Sub WhateverCode()
Dim Name as String
Name=pName
pName = pkh
End Sub

Thanks,
pkh

 

[RoryA]

1. It allows you to do validation of the values.
2. How is your second code better/different, as it doesn't allow you to pass a value?

The idea is that your class behaves like other objects in VBA, so you can use:

myObj.Name = "blah"

 

[pkh]

Rory,

Thanks for the explanation. I see what you mean. Classes and their attendent procedures have been bit of a learning curve for me.

pk