State Clinton (D) Trump (R) 2 Arizona 3 Colorado* 4 Florida 5 lowa* 6 Maine* 7 Michigan 8 Minnesota 9 Nevada 10 New Hampshire 11 North Carolina 1,161,167 1,338,870 4,504,975 653,669 357,735 2,268,839 1,367,716 539,260 348,526 2,189,316 1,252,401 1,202,484 4,617,886 800,983 335,593 2,279,543 1,322,951 512,058 345,790 2,362,631 Create a macro The sub procedure in VBA must ask the user to specify Trump or Clinton using an input box (InputBox). Fox example, the input box should say, Total votes for which candidate? prompting the user to specify Trump or Clinton Then sum the total number of votes for the candidate specified and display that sumtotal using MsgBox. For example, if the user input Clinton, then the MsgBox would say, Clinton received a total of 14,703,073 votes.

State Clinton (D) Trump (R) 2 Arizona 3 Colorado* 4 Florida 5 lowa* 6 Maine* 7 Michigan 8 Minnesota 9 Nevada 10 New Hampshire 11 North Carolina 1,161,167 1,338,870 4,504,975 653,669 357,735 2,268,839 1,367,716 539,260 348,526 2,189,316 1,252,401 1,202,484 4,617,886 800,983 335,593 2,279,543 1,322,951 512,058 345,790 2,362,631 Create a macro The sub procedure in VBA must ask the user to specify “Trump or “Clinton” using an input box (InputBox). Fox example, the input box should say, “Total votes for which candidate?” prompting the user to specify “Trump” or “Clinton” Then sum the total number of votes for the candidate specified and display that sumtotal using MsgBox. For example, if the user input Clinton, then the MsgBox would say, “Clinton received a total of 14,703,073 votes.” Show transcribed image text