How to handle text on a worksheet

[winny]

My workbook includes two worksheets: the first garners user input and the second generates a form for a customer to sign based on the user input. Depending on circumstances, I need the user to select one of 4 lengthy text statements to complete the customer form. In this case "lengthy" means that each statement is between 15 and 22 rows by 8 collumns wide.
My current solution is to include all 4 statements on the customer form. The user sheet that generates informaiton for the customer form contains a group of 4 forms toolbar option buttons, each of which is tied to a macro. Pressing an option button calls a macro that hides rows of text so that the printed form contains only relevant text. There are obvious problems with this approach, the most galling of which is that it seldom works.
Please show me another way to do this. Inserting text boxes and MS Word objects has not worked very well either (likely due to my inexperience and lack of knowledge). I hope this explanation is sufficient and that someone can help me. Thank you.
Winston

 

[Joe Was]

Put a TextBox on your form.
Above the TextBox build a DropDown list from Data-Validation, listing the names of the 4 choices.
Use a Change Event for that Sheet to test for the DropDown value which loads a Select Case statement that populates your TextBox with the proper Strings, replacing the blank text or the previously selected text.

As the user selects one of 4 choices from the DropDown it's text over-writes the TextBox.