Macro: A command button in MS Excel

You can create a command button in your Excel worksheet and code it to do calculations automatically. In the example shown in the video below, you create a command button and code it using the Visual Basic Editor to accept a name and a salary on double click and the other calculations like House Rent Allowance (HRA), etc. are done automatically.