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
- What is VBA in Excel 2016 | 2013 | 2011 | 2010 | 2007 | 2003
- Display the Developer tab in the toolbar in Excel 2016 | 2013 | 2011 | 2010 | 2007
- Open the Visual Basic Editor in Excel 2016 | 2013 | 2011 | 2010 | 2007 | 2003
- Project Explorer in VBA in Excel 2016 | 2013 | 2011 | 2010 | 2007 | 2003
- Properties Window in VBA in Excel 2016 | 2013 | 2011 | 2010 | 2007 | 2003
- Code Window in VBA in Excel 2016 | 2013 | 2011 | 2010 | 2007 | 2003
- Immediate Window in VBA in Excel 2016 | 2013 | 2011 | 2010 | 2007 | 2003
- Watch Window in VBA in Excel 2016 | 2013 | 2011 | 2010 | 2007 | 2003
Learn How to Debug in VBA
- Debug Introduction in Excel 2016 | 2013 | 2011 | 2010 | 2007 | 2003
- Set Breakpoint in Excel 2016 | 2013 | 2011 | 2010 | 2007 | 2003
- Clear Breakpoint in Excel 2016 | 2013 | 2011 | 2010 | 2007 | 2003
- Clear All Breakpoints in Excel 2016 | 2013 | 2011 | 2010 | 2007 | 2003
- Debug Mode in Excel 2016 | 2013 | 2011 | 2010 | 2007 | 2003
- Check Values in Excel 2016 | 2013 | 2011 | 2010 | 2007 | 2003
- Use Immediate Window in Excel 2016 | 2013 | 2011 | 2010 | 2007 | 2003
- Add Watch in Excel 2016 | 2013 | 2011 | 2010 | 2007 | 2003
- Move Through Code in Excel 2016 | 2013 | 2011 | 2010 | 2007 | 2003
- Step Into in Excel 2016 | 2013 | 2011 | 2010 | 2007 | 2003
- Step Over in Excel 2016 | 2013 | 2011 | 2010 | 2007 | 2003
- Continue in Excel 2016 | 2013 | 2011 | 2010 | 2007 | 2003
- Halt in Excel 2016 | 2013 | 2011 | 2010 | 2007 | 2003
Loops
- FOR...NEXT statement to create a FOR Loop in VBA
- WHILE...WEND statement to create a WHILE Loop in VBA
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
- Email the active worksheet in Excel 2007
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
- Open an Access Form from Excel 2003
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
Advertisements