Instead, you can use the VBA editor to create a CalculateTax function that calculates tax based on cell value. It acts just ...

You can also run VBA procedures from the Quick Access Toolbar and a custom group on the ribbon. To learn more about these methods, read How to add Office macros to the QAT toolbar for quick access .

There are lots of ways to execute a VBA procedure in Microsoft Excel. You can add macro buttons at the sheet level or add them to the ribbon in a custom group.