Automate excel sheet to calculate taxable income

Asked By Esteban K Benton 10 points N/A Posted on - 01/30/2015

I am looking into ways to automate an excel sheet so as to calculate my annual tax payments. I heard that VBA can be used to pre-program the excel sheet to accept the annual income and help determine the taxable amount. Has anyone encountered such a use of excel? Is it possible to share a broad template?

• Status: Open
• Question Views: 758
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS Excel

Answered By Dave Crinit 5 points N/A #190544

Automate excel sheet to calculate taxable income

Hello!

Happy to support you!

Yes of course. VBA can definitely be used to create user defined complex workbooks as in your case. It supports expert calculation capabilities with high flexibility as it is a version of VB that is specifically designed to be used with Excel.

• Firstly, get Visual Basic for Excel installed if it is not available in your computer.
• Secondly, the macro security level needs should be set low.
• Thirdly, the Developer ribbon needs to get displayed if it is not.                                                            

If you have a fair knowledge in Excel & some main VBA functions, then you can easily get your work done by following the VBA tutorial guides as well.                                     

About Dave Crinit

Questions
0

Answers
211

Best Answers
1

• Vote Up 0 Vote Down

• Posted on - 03/27/2015
• Question Category: MS Excel