I'm creating a FORM in EXCEL. In the form, the user will select a drop down
list of 4 items, "Screen 1, Screen 2, Screen 3, Screen 4". When the select
which screen they want, I need to create a data entry field for them with
restrictions on the number of lines and characters per line. i.e. if they
select Screen 1, they receive a data entry field of 4 lines x 26 characters.
(i could use a character max if necessary as oppose to lines and characters.
If they select Screen 2, they receive a data entry field of 2 lines x 12
characters, and so forth.

I've been playing with data validation and using IF statements trying to
pull from a sub worksheet, but to no avail. I'm not big on programming in
EXCEL or even know if this is possible. Any help would be appreciated.