Excel - Data Validation -- Display Input

Messages in a Text Box

Set up the Workbook

Create a Data Validation Dropdown List

Add the Text box

Name the Text box

Add the Code

Test the Code 

Show Longer Messages

Microsoft Accredited IT Training Provider

Microsoft Certified Training Materials

IT Training Courses delivered by Microsoft Accredited Facilitators

Microsoft MOS Test Centre London