class foo
Public Property Get ID() As Integer
ID = customerDBSheet.Range("L3").Value
End Property
Public Property Get FirstName() As String
FirstName = txtFName.Text
End Property
Public Property Get LastName() As String
LastName = txtLName.Text
End Property
Public Property Get Address1() As String
Address1 = txtAddress1.Text
End Property
Public Property Get Address2() As String
If txtAddress2.Text = "Address Line 2" Then
Address2 = ""
Else
Address2 = txtAddress2.Text
End If
End Property
Public Property Get Town() As String
Town = txtTown.Text
End Property
Public Property Get Postcode() As String
Postcode = txtPostcode.Text
End Property
Public Property Get Phone() As String
Phone = txtPhone.Text
End Property
Public Property Get Email() As String
Email = txtEmail.Text
End Property
Public Property Get Sex() As String
If (rdMale.Value = True) Then
Sex = Male
Else
Sex = Female
End If
End Property
Public Property Get Username() As String
Username = FirstName + LastName
End Property
Public Property Get PasswordHash() As String
PasswordHash = mdlSHA.SHA1HASH(txtPassword.Text)
End Property
end class