Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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

  #2   Report Post  
Posted to microsoft.public.excel.programming
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/



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formatting the text in an option (radio) button Iriemon Excel Discussion (Misc queries) 0 May 24th 07 06:58 PM
Help with radio button Diana Excel Discussion (Misc queries) 1 July 17th 06 09:29 PM
How do I lock a radio button group if a N/A button is selected worry a lot Excel Discussion (Misc queries) 2 May 21st 05 08:33 PM
VBA: Disable Frame and Radio Buttons based on Another Radio Button Being True Mcasteel Excel Worksheet Functions 2 October 29th 04 07:06 PM
Screen Updates on a userform Neil Excel Programming 2 October 17th 03 01:23 PM


All times are GMT +1. The time now is 05:29 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"