userform Radio button updates text box
 

Is there a way to make a text box update based on a radio butto
selection? Basically, I have a form that I am creating that contains
radio buttons and a text box. I want the text box to update to th
radio button selection when it's chosen.

ie.

o Applied Learning Lab
o Transition Lab 1
o Transition Lab 2


and the text box needs to update to that selection that was just made.

Any ideas

--
Message posted from http://www.ExcelForum.com

userform Radio button updates text box
 

Private Sub OptionButton1_Click()
TextBox1.Text = OptionButton1.Caption
End Sub

Private Sub OptionButton2_Click()
TextBox1.Text = OptionButton2.Caption
End Sub

and so on

HTH. Best wishes Harald

"dok112 " skrev i melding
...
Is there a way to make a text box update based on a radio button
selection? Basically, I have a form that I am creating that contains 3
radio buttons and a text box. I want the text box to update to the
radio button selection when it's chosen.

ie.

o Applied Learning Lab
o Transition Lab 1
o Transition Lab 2


and the text box needs to update to that selection that was just made.

Any ideas?


---
Message posted from http://www.ExcelForum.com/