ttt4

selected or edited' Selection the cell or range of cells that is being selected or selected2. VBA Properties' VBA properties are features of VBA objects' means that a property of an object is represented by theObject.Properties= property valueSub TTT ()Range ("A1"). Value = 100End SubSub TTT1 ()Sheets (1). Name = "Worksheet renamed"End SubSub Ttt2 ()Sheets ("Sheet2"). Range ("A1"). Value = "ABCD" End SubSub Ttt3 ()Range ("A2"). Interior.ColorIndex = 3End Sub3. VBA Method' VBA method is an actio

= "Worksheet renamed" "Rename Workbook to" worksheet renamed "End SubSub Ttt2 ()Sheets ("Sheet2"). Range ("A1"). Value = "ABCD" ' fills the A1 cell of the Sheet2 worksheet with the string "ABCD"End SubSub Ttt3 ()' Inner fill color of cell 'Range ("A2"). Interior.ColorIndex = 3 ' Sets the background color of the A2 cell to redRange ("A2"). Font.ColorIndex = 3 ' Sets the font color of the A2 cell to redEnd Sub9.VBA methodThe VBA method is an action on a VBA object that represents an object that i

' Selection The cell or range of cells that is being selected or selectedVBA Methods and properties: ' VBA Properties ' VBA properties are features of VBA objects ' means of representing properties of an object are ' object. Property = property Value NBSP;NBSP;NBSP;NBSP;NBSP;NBSP;NBSP;NBSP;NBSP;NBSP;SUBNBSP;TTT () Range ("A1"). VALUENBSP;=NBSP;100NBSP;NBSP;NBSP;NBSP;ENDNBSP;SUBNBSP;NBSP;NBSP;NBSP;SUBNBSP;TTT1 () sheets (1). name= "worksheet renamed" endsubsubttt2 () sheets ("Sheet2").

that is being selected or selected　　Two: VBA Objects and properties' One, VBA Properties ' VBA property is the feature of the VBA object ' The method that represents the property of an object is ' object. Property = property value Sub ttt () Range ("A1"). Value = The End Sub Sub Ttt1 () Sheets (1). Name = "Worksheet renamed" End sub Sub Ttt2 () Sheets ("Sheet2"). Range ("A1"). Value = "ABCD" End sub Sub Ttt3 ()

' Selection The cell or range of cells that is being selected or selectedVBA Methods and properties: ' VBA Properties ' VBA properties are features of VBA objects ' means of representing properties of an object are ' object. Property = property Value NBSP;NBSP;NBSP;NBSP;NBSP;NBSP;NBSP;NBSP;NBSP;NBSP;SUBNBSP;TTT () Range ("A1"). VALUENBSP;=NBSP;100NBSP;NBSP;NBSP;NBSP;ENDNBSP;SUBNBSP;NBSP;NBSP;NBSP;SUBNBSP;TTT1 () sheets (1). name= "worksheet renamed" endsubsubttt2 () sheets ("Sheet2").

range of cells that is being selected or selected' One, VBA properties' VBA properties are features of VBA objects' means that a property of an object is represented by the' Object. Property = property ValueSub TTT ()Range ("A1"). Value = 100End SubSub TTT1 ()Sheets (1). Name = "Worksheet renamed"End SubSub Ttt2 ()Sheets ("Sheet2"). Range ("A1"). Value = "ABCD"End SubSub Ttt3 ()Range ("A2"). Interior.ColorIndex = 3End Sub' Second, VBA method' VBA method is an action that acts on a VBA object' m