Excel application updating

For a step-by-step guide on how to create a chart from your Excel data using think-cell, please consider the example from Introduction to charting.

In addition to the data, some cells to the left and on top are reserved for category and series labels.

You can ask the code to display a status message on the status bar so that the user is informed about the current status of the code.

Here is a simple code which gives a message box showing the values in column A starting from row 2 to the last row.

Each time a cell that affects any formula in your spreadsheet is changed or manipulated, Excel recalculates the entire worksheet.

In worksheets that have a large amount of formulas, this behavior can drastically slow down your macros.

Leave a Reply