Rectangle class : Class « Data Type Functions « VBA / Excel / Access / Word






Rectangle class

 

Option Compare Database
Option Explicit

Private dblHeight As Double
Private dblWidth As Double

Public Property Let Height(dblParam As Double)

    dblHeight = dblParam

End Property

Public Property Let Width(dblParam As Double)

    dblWidth = dblParam

End Property

Public Property Get Height() As Double

    Height = dblHeight

End Property

Public Property Get Width() As Double

    Width = dblWidth

End Property

Public Property Get Area() As Double

    Area = (dblHeight * dblWidth) / 2

End Property

Public Sub DoubleSides()

    dblHeight = dblHeight * 2
    dblWidth = dblWidth * 2
    
End Sub

 








Related examples in the same category

1.Creating Custom Objects
2.Creating and Using a Class Module
3.Class Module: FileInformation
4.Class Module: FullName
5.The SimpleLoan Class
6.Loan Object Implementation Details
7.Creating the MyRectangle Class
8.Abstraction