How to handle text on a worksheet

winny

New Member
Joined
Jan 14, 2005
Messages
17
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
 

Some videos you may like

Excel Facts

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college

Joe Was

MrExcel MVP
Joined
Feb 19, 2002
Messages
7,539
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,123,320
Messages
5,600,940
Members
414,417
Latest member
Nobu

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top