Response - Automatic answer in msgbox based on mapping

See attached file for one example of a solution. It uses data validation (list), Vlookup for the answer and Worksheet event code for the messagebox.

AttachmentSize
AutoAnswer.xlsm13.66 KB