Excel VBA color code list – ColorIndex, RGB color, VB color

Posted on August 23, 2015August 23, 2015 by Wyman W

This Excel tutorial collects the VBA color code list for reference purpose, which includes ColorIndex, RGB color, VB color. Excel ColorIndex VBA Excel ColorIndex Property is to set color or get color for Objects like Cell color and Shape color. ColorIndex offers 56 basic colors plus the following special numbers. ColorIndex Value Explanation -4142 / xlColorIndexNone / xlNone No fill -4105 / xlColorIndexAutomatic / xlAutomatic Default color (white) Example 1: Se...

Excel Shortcut key and function

Posted on January 19, 2015January 30, 2017 by Wyman W

This Excel tutorial summarizes a list of Excel shortcut key as well as Windows short cut key which are applicable to Excel. Excel Shortcut key Below is a table that summarizes most Excel shortcut key. I referred to the Microsoft website for the Excel shortcut key, removed some unimportant Excel shortcut key, and then combined with some Windows short cut key that are also applicable in Excel and finally reordered and changed description of each shortcut key. Some keys do not work in older ve...