[090] basics of Excel VBA

Excel Object Model:

• Application Object (Excel): Stab Me !!!
• Font Object (Excel): Stab Me !!!
• Worksheet Object (Excel): Stab Me !!!

Example:

1. Modify the cell color:
   Use the cell's Interior class! The Color attribute can be changed or the background Color of the cell is displayed! ColorIndex uses numbers to modify the background color of cells!
   

   For I = 2 To 19 For j = 2 To 19 If Cells (I, j) = "A" Then Cells (I, j ). select Selection. interior. color = RGB (255,255, 0) 'by selecting and changing End If Cells (I, j) = "C" Then Cells (I, j ). interior. color = RGB (255, 0,255) 'directly uses Cells to modify End If Cells (I, j) = "D" Then Cells (I, j ). select Selection. interior. colorIndex = 2' use the index to modify End If NextNext

   VB, VBA, and VB. NET are similar, but they are different classes!
   Reference: Excel VBA Interior. ColorIndex color list
   Reference: Interior Object Members

2. TBD