change values output by option/radio buttons

It seems like the radio buttons are just assigning numbers to them in the order they were created, so they're all dump in 1,2,3,4,5,5,6,7,etc

instead of 0,1,2,3
0,1,2,3

each set of 4 represents a value and the user will select None, Slight, Moderate, Severe
so for each set of buttons when a selection is made 0,1,2, or 3 needs to be produced depending on which button was selected

each set of 4 is in a group box, but somehow they are all still linked, the second one radio button is pressed the other is deselected. please anyone that can help this is turning into an nightmare

I think I may have figured it out, I group the 4 first buttons and instead of creating new ones all together it made duplicates all that particular group when I was dragging the sheet down to fill it all in with buttons. I'll post in a short while if my solution isn't successful.

I had it working briefly and now I can't anymore. At this point all I need to do is fill in the rest of the chart with the radio buttons, but have each group (set of 4 buttons) correspond to a separate cell on the last sheet.

Also if you know how to change the values that the buttons give from 1,2,3,4 to 0,1,2,3 that would be very helpful as well, otherwise I was going to have them generate their values and then get the values I need in a separate set of cells

rows 13-42 need to have 4 option buttons for in b,c,d,e, is there anyway to populate those cells with the button groups without making a direct copy of the groups above? or do I have to manual enter 4 buttons, group box, group, move in space, each time??

I made a makeshift solution.nvm...

Nice. I've made a few design changes and am working on modifying the code now. We're adding None, Slight, Moderate, and Severe next to each button. I know I have to modify the
OptBtn.Caption = "None, Slight, Moderate, Severe"
But I'm not sure how to get it to assign 1 word to each button. The sizing can be standard, previous I had everything at 0.2" Height and 1" Width. I'm going to keep working on it for now.

I keep getting an error, Run Time error '13': Type mismatch. Is there something in my data sheet not lining up correctly with the code perhaps?

Thanks! Got it up and working, now the hardest thing is developing an interactive popout window lol. I may just use the workaround I had in place though, can''t have it all right?

Here's the current updated sheet. I did a slightly different way to format the buttons once they were set but everything on here is is formatted correctly with the input sheet.

Quick question BTW, is there a way to lock the positioning of the groups and buttons so they I stop selecting them on accident and still make them hide-able? I changed them to don't move and now the "Hide" form button hides just the cells, dumb mistake. I'm guessing I'd have to add into the hide macro a function to change the status of the various groups and buttons to hidden status = true or something along those lines.