View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
vmegha vmegha is offline
external usenet poster
 
Posts: 13
Default 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