Excel VBA

Execute macro on the change of a cell: This code will execute a macro based on a change in the value of a cell. The VBA code uses if then functionality to determine which macro to execute base on the cell value.

Defining and selecting a range in Excel VBA: This Excel VBA code will define a range called myRange and set the variable equal to the current cell selected. The code then selects the defined range.