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.
Attachment | Size |
---|---|
AutoAnswer.xlsm | 13.66 KB |
![]() ExcelExperts.comExcel Consultancy, VBA Consultancy, Training and Tips Call:+442081234832 |
|
Excel / VBA ConsultancyFree Training VideosFree SpreadsheetsExcel / VBA JobsNavigationWho's onlineThere are currently 0 users and 728 guests online.
New Excel Experts
Current Excel / VBA Jobs |
Response - Automatic answer in msgbox based on mappingSee attached file for one example of a solution. It uses data validation (list), Vlookup for the answer and Worksheet event code for the messagebox.
|
Highest Ranked Users
Recent Blogs
ForumsUser login |
Recent comments
6 years 4 weeks ago
6 years 42 weeks ago
7 years 2 weeks ago
7 years 4 weeks ago
7 years 5 weeks ago
7 years 11 weeks ago
7 years 19 weeks ago
7 years 19 weeks ago
7 years 20 weeks ago
7 years 20 weeks ago