I'm having difficulty assigning a value to a private variable within a class. When the code runs pImportKWH retains it's zero value. If I convert the value into a local currency variable within the property I am able to confirm that the conversion from string to currency is occurring correctly. When I try to change the value in the immediate window with "pImportKWH = 4" the locals window shows the value of pImportKWH remaining at zero. Let me know if I can provide any more information.
Private pImportKWH As Currency
Property Let KWH(ByVal value As String)
If IsNumeric(value) Then
pImportKWH = CCur(value)
pImportKWH = 0