VBA Add-in for Excel

VBA macros and UDFs that make your Excel life easier.

Macros and shortcut keys:

Number Cycle - Ctrl + Shift + N

Unit Cycle - Ctrl + Shift + M

Date Format Cycle - Ctrl + Shift + D

Font Color Cycle - Ctrl + Alt + F

Fill Color Cycle - Ctrl + Alt + H

Auto Color - Ctrl + Alt + A

Banded Rows - Ctrl + Alt + B

Dynamic Array to Table - Ctrl + Alt + T

Center Across - Ctrl + Shift + Alt + C

Outside Border - Ctrl + Shift + Alt + =

Remove Border - Ctrl + Shift + Alt + -

Left Border - Ctrl + Shift + Alt + ←

Right Border - Ctrl + Shift + Alt + →

Top Border - Ctrl + Shift + Alt + ↑

Bottom Border - Ctrl + Shift + Alt + ↓

Column Auto Fit - Alt + /

Increase Column Width - Alt + →

Decrease Column Width - Alt + ←

Increase Row Height - Alt + ↓

Decrease Row Height - Alt + ↑

Hide All Other Sheets - Ctrl + Shift + Alt + H

Unhide Sheets - Ctrl + Shift + Alt + U

Unpivot Table

Swap - Ctrl + Shift + S

Trim - Ctrl + Shift + T

Formula to Value - Ctrl + Shift + V

Paste Formula - Ctrl + Shift + Alt + F

Paste Format - Ctrl + Alt + P

Paste Value - Ctrl + Shift + Alt + V

Error Wrap

Refresh Selection

Show Precedents - Ctrl + Shift + P

Next Precedent - Ctrl + Shift + ↓

To Original Cell - Ctrl + Shift + O

Unprotect VBA

Unprotect Workbook

Dark Mode - Ctrl + Alt + D

Light Mode - Ctrl + Alt + L

Calculator - Alt + C

UDFs:

BSM (option pricing)

CAGR

CellColor (return color index, RGB, or hex code)

ChartAxis, ChartSize, ChartTitle

CubicSpline

Eval

RegexExtract, RegexMatch, RegexReplace (add reference to Microsoft VBScript Regular Expressions 5.5)

SheetCount, SheetName

SumColor

Unpivot