LaoMa
05-27-2014, 02:35 AM
I'm tring to use a global variable, but I got some problems.
here the architeture of my VBA.
1. I create a Class Module named DatiVent
Option Explicit
Private m_Famiglia As String
private m_Name As string
.....
Public Property Get GetFamiglia() As String
Famiglia = m_Famiglia
End Property
Public Property Set SetFamiglia(value)
m_Famiglia = value
End Property
.....
2. then I create a Module named VarVENT where I create a public variable
Public VARIABILI As DatiVent
3. I'm tring to use the variable in a Form object:
VARIABILI.SetFamiglia ("PIPPO")
it dosen't work, I'm not an expert, This is the first time I'm using a more complex architeture, someone could help me?
thank you in advance
here the architeture of my VBA.
1. I create a Class Module named DatiVent
Option Explicit
Private m_Famiglia As String
private m_Name As string
.....
Public Property Get GetFamiglia() As String
Famiglia = m_Famiglia
End Property
Public Property Set SetFamiglia(value)
m_Famiglia = value
End Property
.....
2. then I create a Module named VarVENT where I create a public variable
Public VARIABILI As DatiVent
3. I'm tring to use the variable in a Form object:
VARIABILI.SetFamiglia ("PIPPO")
it dosen't work, I'm not an expert, This is the first time I'm using a more complex architeture, someone could help me?
thank you in advance