Excel Articles
This page lists all articles currently available on this site (articles that fall under various categories will be listed at each one).
VBA
- Create Addins: How to rework a macro so it is ready for distribution (as e.g. an addin)
- Smart VBA Macro Recording (YouTube video), Presentation at the Excel Virtually Global conference, July 23rd, 2020
- Handling Worksheet control events using a class module
- How to put the CallByName function to use to find cells by a specified property.
- A macro to change the formatting of cells so they only show a predefined number of significant digits
- An example of how to disable your events
- VBA Bug: Macro in Excel Stops After A Workbook.Open Command
- How to use Parameters With Web Queries
- An article about Registering a User Defined Function with Excel, showing how to show argument descriptions in the function wizard
- A method to enable the user to undo changes done by your VBA routines
- Getting a range from the user with VBA (Bug in Application.InputBox function)
- Transpose a table of cells without garbling formulas
- Docking your windows in the VBE
- Updating addins through the internet
- Installing An Excel Add-in Using Setup Factory (also shows how Excel add-ins are managed in the registry)
- Working with Data Tables in Excel 2007 (VBA)
- The Excel 2007 File format; Working with Worksheet data
- The Excel 2007 File Format; Changing properties of Form controls
- The Excel 2007 File Format; Editing elements in an OpenXML file using VBA
- The Excel 2007 File Format; Adding RibbonX code to an Office OpenXML file using VBA
- A simple Object listing tool
- Catching Paste Operations (prevents wrecking of your validation)
- Showing An Array On A Form; Autosizing ColumnWidths Of A ListBox
- Fixing links to UDFs in an addin
- Editing elements in the OpenXML file using VBA
- Preventing Workbook_Open event from running
- Declaring API functions in 64 bit Office
- Pivottable Slicers
- Keeping modeless userforms on top of Excel
- An MSForms (all VBA) treeview
- A class module to measure performance of your VBA code
- Building an Excel Add-in
- Wheel of Fortune
- Enabling Drag and Drop between two Listboxes on a VBA Userform
Various stuff
- Working with Data Tables in Excel 2013, 2010 en 2007
- Working with Data Tables in Excel 2013, 2010 en 2007 (VBA)
- Pivottable Slicers
- Excel add-ins fail to load
- Opening Corrupt Excel files
- A Simple Inventory System Built In Excel
- Co-authoring in Office 365. A great feature with an unexpected side-effect
- Data Validation in Excel Displaying help out of the way
- XML and Excel
- Creating webpages with Excel Web App mashups
- A Generic Spreadsheet Template
- Excel Data Types
- Fitting curves to your data using least squares
Defined names
- Updated and greatly improved!!! Excel names: A paper about Excel's defined names.
- Show a picture from a list of pictures
- Charting a mathematical equation using just defined names
Trouble shooting
- Corrupt files: Opening corrupt workbook files.
- Startup problems: A list of things to do to fix them.
- Working with Circular references in Excel
- Co-authoring in Office 365. A great feature with an unexpected side-effect
Charting
- Charting a mathematical equation using just defined names
Cell formatting
- A macro to change the formatting of cells so they only show a predefined number of significant digits
- Working with cell styles
- Creating a user-friendly Data Validation in Excel Displaying help out of the way
Formulas
- A small macro to wrap formulas in a range in an error test, from e.g. =Formula to =IF(ISERROR(Formula),"",Formula)
- Transpose a table of cells without garbling formulas
- Excel data table recipe, batchprocessing: how to calculate your model with many input values
- Working with Circular references in Excel
Forms
External Data
User Defined functions
- An article about Registering a User Defined Function with Excel, showing how to show argument descriptions in the function wizard
Other Applications
- Installing An Excel Add-in Using Setup Factory (also shows how Excel add-ins are managed in the registry)