Q1) If you wish to take in and store user's name in cell A1 by having them type their name following prompt declaring "Give me your name, Earthling!" that code excerpt must you use within button subprocedure?
Answer
a. InputBox("Give me your name, Earthling!" , "Earthling Name Retrieval" , "T.S. Garp" ) = Range("A1").Value
b. Range("A1").Value = InputBox("Earthling Name Retrieval", "Give me your name, Earthling!" , "T.S. Garp")
c. InputBox("Earthling Name Retrieval" , "Give me your name, Earthling!" , "T.S. Garp") = Range("A1").Value
d. Range("A1").Value = InputBox("Give me your name, Earthling!" , "Earthling Name Retrieval" , "T.S. Garp").