Private 上底1 As Double Private 下底1 As Double Private 高1 As Double Private Rng As Range '仅为演示用 Public Property Get 面积() As Double 面积 = (上底1 + 下底1) * 高1 / 2 End Property Public Property Let 上底(SD As Double) 上底1 = SD End Property Public Property Let 下底(XD As Double) 下底1 = XD End Property Public Property Let 高(GG As Double) 高1 = GG End Property Public Property Set 范围(FW As Range) Set Rng = FW End Property Public Property Get 范围() 范围 = Rng.Address End Property
模块中代码:
Sub 梯形面积() Dim tx As New 梯形 '实例化一个类,即分创建名称叫tx的梯形类对象 tx.高 = 10 '重新设置它的高度 tx.上底 = 2 '重新设置它的上底 tx.下底 = 3 '重新设置它的下底 Set tx.范围 = Range("A1") MsgBox tx.面积 '计算它的面积 MsgBox tx.范围 End Sub
Private 上底1 As Double Private 下底1 As Double Private 高1 As Double Private Rng As Range '仅为演示用 Public Property Get 面积() As Double 面积 = (上底1 + 下底1) * 高1 / 2 End Property Public Property Let 上底(SD As Double) 上底1 = SD End Property Public Property Let 下底(XD As Double) 下底1 = XD End Property Public Property Let 高(GG As Double) 高1 = GG End Property Public Property Set 范围(FW As Range) Set Rng = FW End Property Public Property Get 范围() 范围 = Rng.Address End Property
模块中代码:
Sub 梯形面积() Dim tx As New 梯形 '实例化一个类,即分创建名称叫tx的梯形类对象 tx.高 = 10 '重新设置它的高度 tx.上底 = 2 '重新设置它的上底 tx.下底 = 3 '重新设置它的下底 Set tx.范围 = Range("A1") MsgBox tx.面积 '计算它的面积 MsgBox tx.范围 End Sub
Sub tianchong() Dim myc As New myclass myc.颜色 = 3 Set myc.设置颜色的单元格 = Range("c1") myc.设置颜色 End Sub
myclass类中:
Public yanse As Integer Public myrg As Range Public Property Let 颜色(A As Integer) yanse = A End Property Public Property Set 设置颜色的单元格(rn As Range) Set myrg = rn End Property Sub 设置颜色() myrg.Interior.ColorIndex = yanse End Sub
Public Property Let 颜色(A As Integer) yanse = A '传递形参A的值,给公共变量yanse End Property Public Property Set 设置颜色的单元格(rn As Range) Set myrg = rn '传递形参rn的值,给公共变量myrg End Property