4105 / xlColorIndexAutomatic / xlAutomaticĮxample 1: Set Cell A1 font color to red Range("A1").Font.ColorIndex = 3Įxample 2: Set Cell A1 back color to red Range("A1").Interior.ColorIndex = 3Įxample 3: Set Cell A1 border color to red Range("A1").Borders.ColorIndex=3Įxample 4: Get Cell A1 ColorIndex col = Range("A1").Interior.ColorIndex Excel RGB color ColorIndex offers 56 basic colors plus the following special numbers. VBA Excel ColorIndex Property is to set color or get color for Objects like Cell color and Shape color. This Excel tutorial collects the VBA color code list for reference purpose, which includes ColorIndex, RGB color, VB color.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |