cellMatrix.net

Spreadsheet Modeling and Related Topics

Creating Charts in Excel 2003 with VBA

This article from Microsoft describes how to create charts in Excel 2003 using VBA.

Posted on Thursday, October 08, 2009 | Comments (0) | Permalink

Simple Guide to the Excel 2003 Object Model

Learn how easy it is to use the Excel 2003 Object Model to customize the way you work with Excel.

Posted on Wednesday, October 07, 2009 | Comments (0) | Permalink

Link Chart Title, Label, or Text Box to Worksheet Cell

This Microsoft article described how you can link a chart title, label, or text box to a worksheet cell in Excel 2003.

Posted on Tuesday, October 06, 2009 | Comments (0) | Permalink

The Power of Arrays

The Journal of Accountancy demonstrates how arrays can speed and simplify your work while making it less prone to errors.

Posted on Sunday, October 04, 2009 | Comments (0) | Permalink

AutoCorrect Options

The Journal of Accountancy describes how you can access Excel's autocorrect function to stop Excel from displaying the copyright symbol when you really want "c".

Posted on Saturday, October 03, 2009 | Comments (0) | Permalink

Office Developer Center

The Office Developer Center provides a wealth of information concerning the Excel chart object model.

Posted on Tuesday, September 29, 2009 | Comments (0) | Permalink

Identifying Unique Values in an Array or Range

The Spreadsheet Page provides a series of VBA functions that extract unique values from an array or range.

Posted on Sunday, September 27, 2009 | Comments (0) | Permalink

RibbonX Visual Designer

The RibbonX Visual Designer is a VBA add-in that is designed to help with the construction of Ribbon interfaces. It is available for free when you visit Andy Pope's AJP Excel Information site.

Posted on Thursday, September 24, 2009 | Comments (0) | Permalink

Add Label to Point from External Range

John Green shows how to use VBA to add a label to a point by referencing a range other than the original source.

Posted on Monday, September 07, 2009 | Comments (0) | Permalink

Precedent and Dependent VBA

Two posts from Bill Manville to the Microsoft Excel Programming Discussion Group show how to use VBA to find precedent and dependent cell references:
August 13, 2001 | September 7, 2001

Posted on Monday, September 07, 2009 | Comments (0) | Permalink

Page 3 of 4 pages  <  1 2 3 4 >

Entries by Day

Jul - 2010
S M T W T F S
27 28 29 30 1 2 3
4 5 6 7 8 9 10
11 12 13 14 15 16 17
18 19 20 21 22 23 24
25 26 27 28 29 30 31