How to get Dynamic Text in Text Boxes?

[all4excel]

Hi!

I am using the Control ToolBox - > TextBox and want to use Dynamic Text in this TextBox as this text is to be changed for different conditions.

Is that possible and How Do I achieve that?

 

[Smitty]

Sure it's possible, but you'll need to answer some questions:

What are the conditions/resulting text?
Where do you want to pull them from (code or worksheet)?
What's the trigger for the TextBox to change?

The more specifics you can give the better.

 

[all4excel]

Sure it's possible, but you'll need to answer some questions:

What are the conditions/resulting text?
Where do you want to pull them from (code or worksheet)?
What's the trigger for the TextBox to change?

The more specifics you can give the better.

I am making a Questionnaire where each question has 5 options..
Each option has a Radio-Button and Text-Box to store the value of the Option...
Ex: What is 2 raise to 10?
0 A. 512 0 B. 256 0 C. 1024 0 D. 2048 0 E. NA

In the above the zero "0" depicts an Radio Button with 5 choices from A,B,C,D and E...

The Boldened Red i.e 512,256,1024,2048 and NA are all the actual answers and it would change depending on the questions chosen for the Test.

Several questions would be stored in a Sheet called Question-Database with the Questions and their 5 options next to it in adjacent Columns..

Now In another Sheet called Questionnaire, I would be selecting any Question No and the Question i.e. Q1.What is 2 raise to 10?
would be pulled by VLOOKUP when I put 1 in the adjacent cell?
But I also need to have the relevant options shown below the selected question which would be different for each question?

So I need some mechanis which updates the Radio-Buttons Labels correctly.? Since I'm using Control Text-Boxes I would like to know how to get dynamci values for the same?
I am willing to use any other approach too if thats feasible...

Hope I have been able to explain the requirment correctly..

 

[all4excel]

Sure it's possible, but you'll need to answer some questions:

What are the conditions/resulting text?
Where do you want to pull them from (code or worksheet)?
What's the trigger for the TextBox to change?

The more specifics you can give the better.

Hope the conditions are as explained in the earlier thread...

The First Sheet -> Lets say Sheet1!$G2

The trigger for the change would be the value entered in the cell A2 of the second Sheet2...by typing the Question No..