How to Add a Calculator to Microsoft Excel 200


To add a calculator to Microsoft Excel 2000, follow these steps:

1. Open Microsoft Excel 2000.

2. Click on "View" on the top menu bar and select "Toolbars".

3. From the drop-down list, select "Forms".

4. Click on the "Controls" button in the Forms toolbar.

5. Select the "Button" control from the list of controls.

6. Draw the button on the worksheet where you want the calculator to appear.

7. Right-click on the button and select "Assign Macro" from the pop-up menu.

8. In the "Assign Macro" dialog box, click on the "New" button.

9. In the "Macro Name" field, enter a name for the macro, such as "Calculator".

10. Click on the "Create" button.

11. In the Visual Basic Editor, enter the following code:

Sub Calculator()

   Application.Dialogs(xlDialogCalculator).Show

End Sub

12. Save the macro and close the Visual Basic Editor.

13. Click on the button to open the calculator.

14. Use the calculator to perform calculations and then close it when you are done.

That's it! You have now added a calculator to Microsoft Excel 2000.