VB for Applications

Functions

Array

Fix

Int

Join

Sgn

Split

Vba

Methods

Evaluate

Range.find

Texttocolumns

Properties

Range.offset

Statements

Do loop

For next

Goto

If then else elseif end if

Select case

Set

With end with

VBA

Array variables

Combo boxes

Dialog boxes

Files

Like operator

List boxes

Text boxes

Macro

Copy n-th row

Copy from workbooks

Non-contiguous rngs

Select blank cells

Quick access toolbar

Run macro when open

How to - Dialog boxes

Multiply numbers in each row by entire cell range

How to save specific multiple worksheets to a pdf file programmatically

Find literal values in formulas

Consecutive values

How to create a list of comments from a worksheet programmatically

Copy filtered tables

How to highlight row of the selected cell programmatically

Add macro to ribbon

Text boxes

Show/Hide image [VBA]

Toggle hidden sheets

Toggle hidden column

Scroll bar

Date ranges overlap

Count text string in all formulas in a worksheet [VBA]

Locate a shape in a workbook

Working with FILES

Change a pic

Move a shape [VBA]

Macro - Dropdown

Hide specific columns

Copy worksheets in active workbook to new workbooks

Copy table criteria

Excel calendar [VBA]

Extract cell references

Sort cell delimiter [VBA]

Quickly create sheets

Click to select series

Sort Excel table [VBA]

Split values

Search related tables

Create comment if cell value is larger than column

Select a cell

Getting things done

Normalize data [VBA]

Add values to sheets

Add values to table

Add value to drop down

Open Excel files

Button on/off macro

Automate data entry

Data validation list

Log WB activities

Auto resize columns

Copy expanding range

List open workbooks

Basic data entry [VBA]

List Excel tables

Comboboxes

Drop down list

Filter Excel Table

Populate combobox (2)

Drop-down list [VBA]

Filter Table [VBA]

Populate listbox(2)

Populate combobox

Add item - context menu

Select A1 on all sheets

Save to Add-In

Group text / Text-to-cols

Create a Print button

Select/View invoice

Populate listbox

Edit invoice data [VBA]

Save invoice data – VBA

Consolidate sheets

Rearrange data

Split data across sheets

Schedule calendar

Unique dist. list

Missing numbers

User defined function

Text between words

Search for file in folders

Split strings & search

Comma separated vals

Count cell color

Replace text strings

Lookup merged values

Display vals based rng

Extract filtered table

Rearrange data

Two-way lookup

SUMIF across sheets

List files in folders

Save to Add-In

Uniq. dist. case sens.

Word frequency [UDF]

No net close to zero

Find numbers in sum

Permut w/o repetition

Permut with repetition

Values not shared

Shared values

Extract duplicate values

Count unique dist. vals

Unique strings [UDF]

Unique distinct strings

Split duplicate strings

Split strings

Group values equally

Files and folders

Copy from workbooks

Search for file in folders

Edit file names

Unzip files

Filter duplicate files

Compare file names

Search workbooks(1)

Move data to workbooks

Search workbooks(0)

File passw. protected

Working with FILES

Filename hyperlinks

Open Excel files

List files in folders

Check boxes

Multi-level To-Do list

Open Excel files

Button on/off macro

Copy checkboxes 2/2

Add checkboxes 1/2

Sum using checkboxes