Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel duplicated a sheet. how do i delete one | Excel Worksheet Functions | |||
Duplicated occurrences of class variables - VBA in Excel | Excel Programming | |||
Why do I get a duplicated column in Excel? | Excel Worksheet Functions | |||
Public variables and Class | Excel Programming | |||
RaiseEvent from a class contained in a 2nd class collection? | Excel Programming |