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:
Private Sub CommandButton1_Click()
Dim ssheet As Worksheet
Set ssheet = ThisWorkbook.Sheets("Calculator")
nr = ssheet.Cells(Rows.Count, 1).End(xlUp).Row + 1
ssheet.Cells(nr, 1) = Me.cboBusiness
End Sub
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.
Bookmarks