Dialog boxes
Excel » VBA » Dialog boxes »
A dialog box is an excellent alternative to a userform, they are built-in to VBA and can save you time […]
VB for Applications
Functions
Methods
Properties
Statements
VBA
Multiply numbers in each row with remaining rows in cell range (UDF)
How to save specific multiple worksheets to a pdf file programmatically
Find literal values in formulas
How to create a list of comments from a worksheet programmatically
How to highlight row of the selected cell programmatically
Count text string in all formulas in a worksheet [VBA]
Copy worksheets in active workbook to new workbooks
Create comment if cell value is larger than column
Excel » VBA » Dialog boxes »
Formula categories
Count Dates Extract Index and Match Logic Lookups String manipulation Sum Time Vlookup