Excel Userform - Select an option, fill a text box?

[hobbes922]

Hello,

For a userform, I am looking for a code that will enter a certain text into a textbox when 4 option boxes are clicked.

For example,

OptionBox1, OptionBox2, OptionBox3, and OptionBox4 are selected.
Textbox1 populates with "text".

Does anyone have any idea how to do this?

Thanks!

 

[bjurney]

Hello,

For a userform, I am looking for a code that will enter a certain text into a textbox when 4 option boxes are clicked.

For example,

OptionBox1, OptionBox2, OptionBox3, and OptionBox4 are selected.
Textbox1 populates with "text".

Does anyone have any idea how to do this?

Thanks!

Hi Welcome to the board.

Something like this?


If Optionbox1.Value = True and Optionbox2.Value = True and Optionbox3.Value = True and Optionbox4.Value = True Then
Textbox1.Text = "text"
End If

 

[hobbes922]

It didn't seem to work...

I added this code under the code for the textbox.

 

[bjurney]

I called them Optionboxes, should have been OptionButton. That should work for you.

 

[hobbes922]

Hi bjurney,

Thanks for the reply. I have renamed all of my option buttons and wrote in teh corresponding names. Didn't seem to work.

I should mention that I placed this code after clicking on the textbox I added to the userform. Maybe it doesn't belong there?

 

[bjurney]

Well it depends on when you want the "text" to be in the textbox. If you want it to appear in the textbox after you click on it, then you can keep the code as is. Or if you want it to take effect when you press a button, you can put it in with a Button Click event.

Are your optionbuttons independent from each other, or can only one be clicked "True" at a given time?

 

[hobbes922]

I'd like for the textbox to automatically populate when the options are selected.

All four option boxes are independent, and in their own group.

The code works well if I use it under my "Next" option button, though.