Swap out text in text box based on radio button selection

**gordco** · 12-12-2012, 11:23 PM

If the user selects French (radio button selection), I want to swap out the existing English text for French and vice versa. One large text box with several paragraphs.
Can Excel do this?
Thanks.

**benishiryo** · 12-12-2012, 11:50 PM

hi gordco, welcome to the forum. i'm assuming you already know how to create the radio button? and since you are using Excel 2003, you are probably using Form Controls.

1. So if you right-click the radio button & Format Controls, give it a Cell Link. I'm going to choose E6 for eg.
2. Do up a table to put the the numbering to lookup later & the 2 different languages of text. I placed mine in F9:G10
3. Do a VLOOKUP formula in F6 based on the cell link to return the different text
4. Insert the text box & click on the outline of it. type in the formula in the formula bar:
=$F$6

you should be done

**gordco** · 12-13-2012, 11:49 AM

Thanks for the welcome, benishyro.
Also, a really big thanks for the example you provided which is the perfect and simple solution to my quandry! You don't know how much time this saves and how this will help.
Gordco