View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Harald Staff Harald Staff is offline
external usenet poster
 
Posts: 292
Default 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/