Excel VBA Color Index List contains 56 colors that is used in the Color palette to change the background color, border or font color. Code for VBA Color.
Conversion of Excel VBA color codes from Long to RGB, Hex and vise versa. VBA color codes can be used on Excel background,interior or font color codes.
Create Drop down list in Excel. It is also called Data Validation list which allows users to enter only predefined values. VBA data Validation list also.
Read the output of Excel vba shell command within macro.Issue any function to execute shell command prompt thru vba Shell & read the output in Excel Macro
Coding Excel VBA 64 bit compatible for 32 bit. Also convert VBA 32 bit to 64 bit by declare PtrSafe 64 bit of Win API functions of VB6 & VB7 editor.
Use this VBA code or Excel app to create Email List using Excel. Created distribution list can be used to email to multiple recipients for Marketing purpose
VBA check if string contains only Letters function in this page can be used in your vba project module & referred in any place to check & trim your string.
Convert a formatted cell in Excel to HTML tag using VBA code. A Cell can have single or multiple font formats. This code converts each type to HTML Tag.
Use this simple technique to get free stock market data as an Excel stock price list. Build your own best live stock ticker using this Excel VBA macro code.