Excel Links on Microsoft Site

Links to Microsoft Excel support articles on key topics, such as Automation, Format, and Versions.

A

ActiveX

• Using ActiveX Controls on Sheets  

Add-ins

• Creating Add-ins in Microsoft Excel

B

Using Early Binding and Late Binding in Automation

C

Class Modules

• Class Modules: Step by Step
• Creating Dynamid Data Structures Using Class Modules

COM Add-ins

• Excel COM add-ins and Automation add-ins

Controls

• How to use the forms controls on a worksheet in Excel

D

How to use dates and times in Excel

E

Handle Run-Time Errors in VBA

Professional Error Handling

F

Format

• How to control and understand settings in the Format Cells dialog box in Excel
• Text or number converted to unintended number format in Excel
• Creating custom number formats

Functions

• Description of limitations of custom functions in Excel

N

Numbers: Floating-Point Arithmetic May Give Inaccurate Results

O

Excel Object Model Overview

Super-Easy Guide to the Excel Object Model

S

Save

• Do not open and save directly from a floppy disk
• Description of the way that Excel saves files
• Error Message When You Try to Save a File

Solver

• Optimization with Excel Solver Tool
• How to create Visual Basic macros by using Excel Solver in Excel 97

Specifications

• Description of Excel specifications and limits

Startup

• Description of the startup switches for Excel
• How to troubleshoot startup problems in Excel

U

Advanced User Forms

Use VBA to Change UserForms

V

VBA

• Getting Started with VBA
• VBA Primer
• VBA Samples for working with worksheets
• Programming with Slicers

Versions:

• Excel 2007 -- Articles List
• Excel 2010 -- Articles List
• Excel 2013 -- Articles List

Related Pages

Video Index

Pivot Table Index

Topic Index

Excel FAQs