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
Rj45 color code > Guide
Powertoys color picker download > Download - Other
Sound card color code > Guide
Html text color > Guide
Notepad++ change background color > Guide

Excel

How to count occurrences of characters and numbers in Excel
Excel send value to another cell
Unlock password protected Excel file: Macro
How to conditionally format Excel data with dates?
How to use Excel auto numbering formula
How to create a timer in Excel VBA
How to update dates in Excel spreadsheet: formula
How to copy data to multiple worksheets in Excel
How to remove leading apostrophe in Excel
Split a workbook into individual files in Excel
How to use an IF statement, excel, with text, vba
How to use Excel color cell if formula
Send email with attachment Excel: VBA, macros
Compare two Excel sheets: and combine data
Select empty cell in Excel: VBA
How to copy a Macro into a blank cell
Transfer Excel data from one sheet to another: VBA
How to export Excel data: from one sheet to another
Transfer a worksheet to another Excel workbook: without VBA
How to insert blank rows using macros in Excel
How to split text in columns in Excel
How to fill multiple Excel sheets from master sheet

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