Toolbar Calculator

Return to The Spreadsheet Page

Excel page

Excel files

Description:

This add-in creates a new toolbar that functions as a simple calculator.

It may not be the most useful tool (it's limited to only the four basic mathematical operations), and I'll be the first to admit that it's fairly ugly. But it does demonstrate some useful VBA programming techniques (the VBA project for the add-in file is not protected).


NOTE: This add-in requires Excel 97 or later.

Installation:

  1. Download the Toolbar Calculator add-in (it's a self-extracting EXE file).
  2. Extract the XLA add-in file by double-clicking the TOOLBARCALC.EXE file.
  3. Start Excel and select the Tools - Add-Ins command. 
  4. In the Add-Ins dialog box, click the Browse button and locate calctoolbar.xla (the file you extracted in Step #2).
  5. Click OK
  6. The toolbar will appear
  7. Select Tools - Toolbar Calculator to toggle the toolbar on and off.