Fill a textbox with varaible text depending on Radio Button selection combo

Hi All,

I need some help with getting the right code to do the following:

* I have 4 groups of radio buttons inside a frame in a userform
* Each group is a simple Yes/No radio button
* I have a textbox that I want to autofill with a score range of A-D depending on the # of "yes" radio buttons selected.
* The "No" checkboxes really shouldn't do anything in regards to the textbox

Userform Name = TP_UF
Frame Name = fun_opt_frame
Option Button Name for "Yes" = fun_score_yes1
Textbox Name = fun_scorebox

Logic:
4 Yesses = A
3 Yesses = B
2 Yesses = C
1 Yes = D

It doesn't matter what order the yesses are selected, its a total count. I tried using code using the frame but not sure if that is the best way. The frame for these radio buttons isn't needed for any reason other then to perhaps make it easier to code. So I could throw out the frame if it's not necessary to get this working.

I am not sure where to start here. Any help would be appreciated.

radio text.jpg

Hi Keebellah,

Thank you for your response. I understand that the behavior is simple but I am don't know vba very well and I am not sure where to get started. Would it be possible for you to provide some sample code?

I am playing around with this code but it currently isn't working. When I have a 4 "yes" radio buttons nothing appears in the textbox

Please Login or Register  to view this content.

then I will just repeat this code for each score. I am sure there is a better way to go about this.

Cheers!
April

Hi Keebellah,

Yes this is what I am looking for except when excel counts the number I want the textbox to display A-D with each count (See Below). Also, sorry for not attaching my spreadsheet, I am unable to publish the entire notebook due to propriety data instead. For me to publish the parts i need help with I would have to create a new notebook and pull out just the elements I need to post It takes a lot of work to do. But I don't mind if it helps get me the help I need. I ended up creating a new notebook to post but I saw you created one already. Thank you for this.

So how I can tell excel that when the counter = 1 then textbox = D, counter = 2, textbox = C, counter = 3, textbox = B, counter = 4, textbox = A

I am playing with the code to try. I may require another variable as string? Again, forgive me, very new to vba

Cheers
April

Hi Keebellah,

What representative data are you looking for? There isn't any "data" I am simply trying to count the number of "yesses" and assign a letter based on that count. I know it may seem like VBA is easy for you but it doesn't come easily to me and its why I am reaching out for help. I can attach my sample spreadsheet for you but it will look just like yours except it's empty. Can we work of yours and see how we can assign a letter to the count of the data? I am not seeing a way to assign a letter to the count based off the way you used the code. Should I use the textbox itself to convert the number to a letter? If you must have the sample worksheet I will attach it when I get home.

Thanks
April

Hi Keebellah!

Yes! This is it! Viewing the code I see what you added, however, I am not sure how the code is working. I will study it so I can learn from this experience. Thank you so much for working with me.

Cheers & Goodnight!
April

Thanks Keebellah, Super helpful tip. I never thought of vba as reading a book.