How to get Dynamic Text in Text Boxes?

all4excel

Active Member
Joined
Feb 15, 2008
Messages
435
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?:confused:
 

Some videos you may like

Excel Facts

How to create a cell-sized chart?
Tiny charts, called Sparklines, were added to Excel 2010. Look for Sparklines on the Insert tab.

Smitty

Legend
Joined
May 15, 2003
Messages
29,536
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

Active Member
Joined
Feb 15, 2008
Messages
435
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

Active Member
Joined
Feb 15, 2008
Messages
435
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..
 

Watch MrExcel Video

Forum statistics

Threads
1,122,511
Messages
5,596,576
Members
414,079
Latest member
Frills

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