totn Excel

MS Excel: Macros / VBA

The following is a list of topics that explain how to use Macros (VBA code) in Excel:

Getting Started in VBA

Learn How to Debug in VBA

Loops

Hyperlinks

  • Extract hyperlink address (web addresses ONLY) in Excel 2003
  • Extract hyperlink address (files and web addresses) in Excel 2003
  • Filter final series of numbers in hyperlink address in Excel 2003
  • Delete all hyperlinks on a sheet in Excel 2003
  • Update cell based on hyperlink selected in Excel 2013 | 2011 | 2010 | 2007 | 2003
  • Create hyperlinks to link cells in column E to their matching value in column C in Excel 2007

Checkboxes

  • Update a cell when a checkbox is clicked (Forms toolbar) in Excel 2003
  • Update a cell when a checkbox is clicked (Control Toolbox toolbar) in Excel 2003

Combo Boxes

  • Link data to a combo box and update underlying data in Excel 2003

Integration with E-mail

Test for duplicates

  • Test for duplicates in a column in Excel 2003
  • Test for duplicates on partial cell contents in a column in Excel 2003
  • Test for duplicates in two columns, combined in Excel 2003
  • Test for duplicates in eight columns, combined (and delete duplicates) in Excel 2003
  • Test for duplicates in eight columns, combined (and delete duplicates and originals that were duplicated) in Excel 2003
  • Test for duplicates in eight columns, combined (and clear the values in the 8 columns when a duplicate is found) in Excel 2003
  • Create a column that must contain unique values in Excel 2003

Test and copy data

  • Test each value in column A until a different value is found in Excel 2003
  • Test each value in column A and copy matching values into new sheets in Excel 2003
  • Test each value in column A and copy matching values into new workbooks in Excel 2003
  • Test each value in column A and copy matching values into new workbooks (name workbooks the value found in column A) in Excel 2003
  • Copy the value in Column B the number of times indicated by the value in Column A in Excel 2003
  • Copy range of cells from one sheet to another sheet matching on date values in Excel 2003
  • Search for a value in a column and copy row to new sheet for all matching values in Excel 2003
  • Enter a value in an InputBox and then search for this value in a column and copy row to new sheet for all matching values in Excel 2003
  • Copy data to various sheets based on the value in column A in Excel 2003

Update formulas

  • Update all formulas to reference data in a particular column in Excel 2003
  • Update all formulas to reference data in a particular row in Excel 2003

Integration with Access

Custom Functions

  • Creating a custom round function in Excel 2003
  • Creating a custom average function (that excludes outlyers from the calculation) in Excel 2003
  • Function that returns Last Modified date for Workbook in Excel

Check if files exist

  • Check to see if a file exists based on a value in column A in Excel 2003
  • Check to see if files exist based on values from 2 columns in Excel 2003

Macro Examples

  • Test range of cells for formulas (or missing formulas) in Excel 2003
  • Automatically refresh pivot table when data in a sheet changes in Excel 2003
  • Automatically refresh pivot table when user switches between sheets in Excel 2003
  • Link one cell to another cell (control the recalculation) in Excel 2003
  • Change the background color of a row based on a cell value in Excel 2003
  • Change the background color of a cell when another cell is selected in Excel 2003
  • Macro to warn when a record will expire within 31 days in Excel 2003
  • Convert currency into words in Excel 2003
  • Overwrite column B value when column A value is higher in Excel 2003
  • Function to calculate total cost based on a tiered fee structure in Excel 2003
  • Autonumber a cell each time the spreadsheet is opened in Excel 2003
  • Convert an entire spreadsheet to proper case in Excel 2003
  • Convert an entire spreadsheet to uppercase in Excel 2003
  • Create custom function to exceed 7 nested If functions in Excel 2003
  • Create a control screen to maintain data on another sheet in Excel 2003
  • Counting matched pairs in Excel 2003
  • Perform a lookup where the reference value is stored somewhere in a string in Excel 2003
  • Cleanup an export of raw data in Excel 2003
  • Rearrange data in an export of raw data in Excel 2003
  • Create a File SaveAs macro in Excel 2003
  • Test a string for an alphanumeric value in Excel 2003
  • Automatically open a Form when spreadsheet is opened in Excel 2003
  • Count the number of cells with a particular font color in Excel 2003