In VBA

Using the Developer Tab, place a button on a worksheet named Prob3. Type your full name (e.g., Joe Doe ) in cell H1 of any of the three worksheets Sales, Prob2 or Prob3 (e.g. Prob3) (assume that the name is spelled correctly and that there are exactly two words with leading and trailing blanks and separated by one or more spaces, but capitalization may be incorrect). When the button is clicked, a VBA macro should run the code that will do the following. (Make sure you save your file as a macro-enabled excel file).

a. An input box will appear asking for the tab name of the worksheet where the full name is specified in cell H1 (assume that the tab name is specified correctly in the Input Box and that the tab name exists).

b. The title on the Input Box should have your full name.

c. The macro will separate the first name and the last name specified in cell A1 of the worksheet entered in the InputBox and will eliminate any extra blanks in the last name and first name

d. The macro will capitalize the first letter of the first name and the first letter of the last name and make all other letters lower case.

e. A messageBox with Yes and No buttons will show a message with three lines of text indicating the processed first and last names (e.g., first line The first name is Joe, second line The last name is Doe, third line, Do you prefer LastName, FirstName fromat?)

f. If the user responds Yes, then the code will print the processed name (i.e., LastName, FirstName) in cell H3 of the worksheet specified in the input box.

g. If the response is No, then the code will print the processed name (i.e., FirstName LastName) in cell H3 of the worksheet specified in the input box.

h. Display a message box with the time (in seconds) that it took to run this sub.