Duplicated occurrences of class variables - VBA in Excel
 

Hi,


I'm using Get and Let methods on an Objects Private Variables called
for eg: OrdSettleDate , etc in my VBA App.


In my debug mode, when I watch the built up object I see two
occurrences of the variables, in the object - OrdSettleDate and
SettleDate


Here're are the let and get methods-


Property Get SettleDate() As String
SettleDate = OrdSettleDate
End Property


Property Let SettleDate(ByVal SettleDate As String)
OrdSettleDate = SettleDate
End Property


Is this normal behaviour?


Any help , will be appreciated,
Thanks,
Megha

Duplicated occurrences of class variables - VBA in Excel
 

I am not sure what problem you are experiencing, but I don't seem to get a
problem with that code.

I personally wouldn't use the same name for a property and its argument as
you do in the Property Let, I would use something like

Property Let SettleDate(ByVal InputDate As String)
OrdSettleDate = InputDate
End Property

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"vmegha" wrote in message
oups.com...


Hi,


I'm using Get and Let methods on an Objects Private Variables called
for eg: OrdSettleDate , etc in my VBA App.


In my debug mode, when I watch the built up object I see two
occurrences of the variables, in the object - OrdSettleDate and
SettleDate


Here're are the let and get methods-


Property Get SettleDate() As String
SettleDate = OrdSettleDate
End Property


Property Let SettleDate(ByVal SettleDate As String)
OrdSettleDate = SettleDate
End Property


Is this normal behaviour?


Any help , will be appreciated,
Thanks,
Megha