Question: table [ [ Taxable income ( R ) , table [ [ Taxable income ( R ) ] , [ Between ] ]

\table[[Taxable income (R),\table[[Taxable income (R)],[Between]],,Base,%],[1-237100,1,237,100,-,18],[237101-370500,237,101,370,500,40,680,\table[[\table[[26],[%]]]]],[370501-512800,370,501,512,800,73,726,\table[[\table[[31],[%]]]]],[512801-673000,512,801,673,000,115,762,\table[[\table[[36],[%]]]]],[673001-857900,673,001,857,900,170,734,\table[[\table[[39],[%]]]]],[857901-1817000,857,901,1,817,000,239,452,\table[[41],[0]]],[\table[[1817001 and],[above]],1,817,001,Above,614,192,\table[[45],[%]]]]
\table[[,Age,Rebate],[Primary rebate,All,17,235],[Secondary rebate,65,9,444],[Tertiary rebate,75,3,145]]
Please assist with the following question.
Using the table above and using Visual Basic for Applications (VBA), kindly advise how can I create button to request the employee's salary as well as the employee's age (in the "Tax tables" worksheet). The calculated result should display via a message box. coding complies to coding best practices
Lastly, please make use of a FUNCTION to calculate the tax payable. Your SUB PROCEDURE should only facilitate the input from and the output to the user. For the selection structure(s), please use IFstatements.
 \table[[Taxable income (R),\table[[Taxable income (R)],[Between]],,Base,%],[1-237100,1,237,100,-,18],[237101-370500,237,101,370,500,40,680,\table[[\table[[26],[%]]]]],[370501-512800,370,501,512,800,73,726,\table[[\table[[31],[%]]]]],[512801-673000,512,801,673,000,115,762,\table[[\table[[36],[%]]]]],[673001-857900,673,001,857,900,170,734,\table[[\table[[39],[%]]]]],[857901-1817000,857,901,1,817,000,239,452,\table[[41],[0]]],[\table[[1817001 and],[above]],1,817,001,Above,614,192,\table[[45],[%]]]] \table[[,Age,Rebate],[Primary rebate,All,17,235],[Secondary rebate,65,9,444],[Tertiary rebate,75,3,145]] Please

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!