VBA Excel Color Codes: Index Number, List

Có thể bạn quan tâm

Computers Mobile Apps & Sites Sound & Image Gaming Security Downloads Forum Social Media Email Instant Messaging Browsers Apps Professional Video Calls

Home
Apps & Sites
Fiches
Software
Office Suites
Excel

David Webb 14 janvier 2022 14:06 Partager Partager

Do you want to find all of the VBA Excel Color Codes? This brief tutorial explains the different color codes for VBA Excel and then the VBA color conversion function.

The VBA color index list

A sample workbook with the codes written down can be downloaded from this link: https://www.cjoint.com/c/DIqlTjoC61G

What is the VBA color conversion function?

This function allows you to convert VBA colour codes from 1 to 56 (Interior.ColorIndex) to their long value (Interior.Color):

Function CouversionCouleurLong(Couleur As Integer) As Long Dim CouleursLng() CouleursLng = Array(0, 16777215, 255, 65280, 16711680, 65535, 16711935, 16776960, 128, 32768, 8388608, 32896, 8388736, 8421376, _ 12632256, 8421504, 16751001, 6697881, 13434879, 16777164, 6684774, 8421631, 13395456, 16764108, 8388608, 16711935, 65535, _ 16776960, 8388736, 128, 8421376, 16711680, 16763904, 16777164, 13434828, 10092543, 16764057, 13408767, 16751052, 10079487, _ 16737843, 13421619, 52377, 52479, 39423, 26367, 10053222, 9868950, 6697728, 6723891, 13056, 13107, 13209, 6697881, 10040115, 3355443, 16777215) 'En cas d'erreur colorie en noir If Couleur < 0 Or Couleur > 56 Then CouversionCouleurLong = 0 CouversionCouleurLong = CouleursLng(Couleur) End Function Partager Partager Around the same subject

Color 65535
Color = 65535
65535 color
Powertoys color picker download > Download - Other
Sound card color code > Guide
Rj45 color code > Guide
Html text color > Guide
Excel color formula > Guide

Excel

Run Macros in Excel: online, shortcuts, VBA
How to create calculator in Excel VBA
How to create multiple checkboxes in Excel using VBA
How to generate email notifications for Excel updates
How to transfer data from one Excel sheet to another?
How to use conditional formatting in Excel
Using VBA to find last non empty row: in column, in table
Repeat rows in Excel: based on cell value, VBA
How to change Excel date format
Excel functions in French
How to use spreadsheets: introduction, formulas, functions
How to manipulate data in Excel: VBA
How to connect VB 6.0 with MS Access
What is the VBA code to select last sheet in workbook
Create new sheet based on cell value: Excel, macro
How to disable auto recover in Excel
How to insert multiple rows in Excel with a macro?
How to automatically transfer data between sheets in Excel
How to clear formatting in Excel
How to enter multiple lines in a single Excel cell
Auto generate serial number in Excel: VBA, formula
Create a new workbook and copy data in Excel via a Macro

Office Suites

Powerpoint bullet list: into animation, SmartArt graphic

Newsletter

Subscribe to the newsletter See an example

This information will be transmitted to CCM Benchmark Group to ensure the delivery of your newsletter.

It will also be used, according to your selected preferences, to provide you with more relevant advertisements.

You have the right to access and modify your personal data, as well as to request its suppression, within the limits foreseen by the legislation in force.

You can also change your preferences regarding the advertisements you receive at any time. For more information, please check our privacy policy. Processing of Personal Data.

Trending

Study Reveals: A Single Factor Can Reduce Your Risk of Dying by Nearly 40 Percent
Remember the Kinder Chocolate Kid? He's Finally Revealed Himself After Years of Identity Theft
"Outrageous Predictions" for 2025: This Bank Makes Bold Forecasts for the Future
Why Do Some Names Cause ChatGPT to Crash? (No, It's Not a Conspiracy)

Download Software & Apps