Home » Forums » Open Source Learning Center » Question and Answer

Response - Automatic answer in msgbox based on mapping

Submitted by AndyLitch on 20 November, 2012 - 16:01

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
‹ Automatic answer in msgbox based on mapping Response to Need help to gather staffs times report ›
»