ColorIndex. Select Case Verzweigungen in Excel VBA nutzen - Unterschiede zur If Then Else Verzweigung. Excel-Version: 9.0 (Office 2000) Re: RGB-Farbwert einer Zelle ermitteln von Boris vom 25.10.2002 - 08:48:40 Kleine Erweiterung von Boris vom 25.10.2002 - 08:52:54 The ColorIndex is also a property. Colors could be very important and useful in excel application. Change Background Color of Cell Range in Excel VBA – Solution(s): We can use Interior.Color OR Interior.ColorIndex properties of a Rage/Cell to change the background colors. Auf diese Hilfsspalte kannst du dann mit deiner Wenn-Formel verweisen. Excel VBA - Die wichtigsten Befehle Folge 17. VBA ColorIndex. There are two ways in which you can get or set the colors in VBA Excel. Instead of using Excel / VBA’s ColorIndex property, you can use the Color property. VBA Color Property. Excel VBA ColorIndex returns index values from 1 to 56, -4105 and -4142. Das ist normalerweise die Farbe schwarz, wenn Sie die Palette nicht verändert haben. VB Color is the easiest way to set colors in VBA. VBA; September 23, 2019 ; Excelbud ; No Comments ; Colors. The following examples will show you how to change the background or interior color in Excel using VBA. Change Background Color of Cell Range in Excel VBA – Examples. You can set the default colors using VBA enumeration number -4105 ( or xlColorIndexAutomatic). Hallo, wenn du mit Colorindex arbeitest dann benötigst du eine Hilfsspalte in der du den Colorindex ausliest. They are: ColorIndex, which has 56 colors, and Color, which has millions of colors and makes it possible to use any color at all. The Color property takes two input types: vbColor; RGB Colors; We will discuss these below: VB Color. VBA ColorIndex Property of Excel VBA is very useful to set the fill colors, border colors and font colors. However, it’s also the least flexible. We have a vba function called as Color Index which is used to change the colors of the cells or the cell range provided, this functions has unique identification for different type of colors. Like in a worksheet we change the color of a cell or a given cell range from the home tab in VBA. Excel VBA Color Index. ActiveSheet.Cells.Interior.ColorIndex = 1 End Sub. Das Makro setzt die Hintergrundfarbe aller Zellen der aktiven Tabelle auf die Farbe, die als zweite Farbe in der aktuellen Farbpalette hinterlegt ist.