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 304 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
5 years 36 weeks ago
6 years 22 weeks ago
6 years 34 weeks ago
6 years 37 weeks ago
6 years 38 weeks ago
6 years 43 weeks ago
6 years 52 weeks ago
7 years 2 days ago
7 years 3 days ago
7 years 3 days ago