UserForm Data Entry with Option Buttons

I am creating a UserForm that has multiple fields in it, such as textboxes, comboboxes, and more. Here is my code right now where I have a combobox that has its data entered into a sheet once a command button is clicked:

Please Login or Register  to view this content.

I was wondering, given a group of option buttons, how could I get the selected option button's value inserted into my sheet? I have been searching quite a bit for this answer but haven't found much besides some very complex code. Thank you.

Do you mean the option button's caption or it's True/False value?

Welcome to the Forum jimmyex23!

First, please take the time to review our rules. There aren't many, and they are all important. Rule #3 requires putting CODE tags around VBA code to preserve readability. Because it's your first post, I've done it for you.

Not sure exactly what you mean by "the selected option button's value". The value of an option button is either TRUE or FALSE. Do you mean the caption of the option button that has been selected from a group? Each option button has a property called GroupName. Only one option button out of the set of buttons belonging to the same group can be TRUE at one time. The code would loop through all option buttons, check what group they are in, and then identify the first one in the group that is TRUE. This code would do that. You have to supply the GroupName.

Please Login or Register  to view this content.

The Group Name doesn't have to be hard coded.
Testing only for GroupName has the problem that option buttons in different frames (different groups) may have the same GroupName (usually vbNullString). Looping through the Parent of a particular option button and checking the GroupName will keep different-grouped option buttons out of the mix.

Please Login or Register  to view this content.