One TextBox containing the chosen results of multiple TextBoxes

Please help.

I’m fairly new to VB (using Excel 2007) and I’m pulling the rest of my hair out with this one. I keep trying but keep failing which makes me think it’s not possible (probably that I’ve still a lot to learn about VB).

Top level summary:

A user answers a series of questions and each question corresponds to a predefined textual answer. Upon each question being answered a single TextBox gets populated with the combined textual answers.

Some specifics:

I want to be able to populate a single TextBox1 (in Sheet 3) with text from a series of already populated TextBoxes (4 TextBoxes per question) in Sheet 2. The plan is that the user answers a series of questions from a value (ranging from 1 to 4) in each question (Sheet 1) and each chosen value (1,2,3,4) is lodged in locations i5 to i60 on Sheet 1 and whichever values the user has chosen corresponds to a series of already populated TextBoxes (each question has four answers). As the user progresses through each question (all 55 questions) I need the textual answers (from already populated and formatted TextBoxes in Sheet 2) to be displayed (keeping their original formatting) in TextBox 1 (in Sheet 3) so I end up with one TextBox containing all of the textual answers that the user has chosen automatically. I hope that makes sense.

Re-worded version of above:

• Sheet 1 contains; 55 questions whereby the user chooses 1 of 4 (multiple choice answers) of each question and the answer (1 or 2 or 3 or 4) is populated in Sheet 1 Cell’s i5 to i60.
• Sheet 2 contains; 55 rows of TextBoxes. Each row contains 4 TextBoxes. These TextBoxes contain 4 possible answers to each question in Sheet 1. Each TextBox is populated with formatted text.
• Sheet 3 contains; 1 TextBox with the merged/ populated answers (from Sheet 2) from all the questions chosen in Sheet 1.

Please help!

@ brynbaker

Please notice that [CODE] tags have been added to your post(s). The forum rules require them so please keep that in mind and add them yourself whenever showing code in any of your future posts. To see instructions for applying them, click on the Forum Rules button at the top of the page and read Rule #3.
Thanks.

Hi. As requested I've now uploaded the file.

Thanks for that. It shows me that it's NOT the formatting you are interested in.
Are you expecting your users to read the questions on Sheet2 and answer on Sheet1? Surely not, but if so, I would strongly recomend a cleaner UI and the coding could then be very much easier.

Hi brynbaker. This is driving me mad so your help is much appreciated.
The user will only 'see' Sheet 1. So, Sheet 2 and Sheet 3 will be hidden from them.
The user will answer the questions within Sheet 1 and a user 'score' number (1 to 4) will be generated for each question they answer within Sheet 1.
I then want Sheet 2 to see take the scores (from Sheet 1) and populate the TextBox (in Sheet 3) with the score related TextBoxes (Sheet 2).
So, lets say the user answers question 1 by scoring 2. The TextBox (in Sheet 3) would see this score and drag across Question 1, Answer 2 (from Sheet 2).
Hope that makes sense!

Very interesting. My very secure PC won't download your file; something in the link makes it expect PHP when it's xlsm so I can't help here.

I've researched again and found the VBA code for handling textboxes. It is a popular currect request.
Here is a generic example that should help.

Please Login or Register  to view this content.

This should collect all the text values and store them in the bag collection for you.
You could collect them in several different ways, inclding directly into the other textbox.