I am building a userform to track seminar invitation responses. Amongst other things, the form will contain three option buttons; "Accept, Decline, No Response". However, I am having issues with the coding and cannot find any online resources to help me.
There will possibly as many as 500 records that will be saved to a spreadsheet. I *think* my main issue is with the Range always pointing to C3.
It would be great if anyone has any suggestions or can point me to a good online resource.
TIA
Here is the code I have so far:
Code
Private Sub optOptionButton1_Click()
If Userform1.optOptionButton1.Value = True Then
Guest_List.Range("C3") = "Accept"
End If
End Sub
Private Sub optOptionButton2_Click()
If Userform1.optOptionButton1.Value = True Then
Guest_List.Range("C3") = "Decline"
End If
End Sub
Private Sub optOptionButton3_Click()
If Userform1.optOptionButton1.Value = True Then
Guest_List.Range("C3") = "No Response"
End If
End Sub
Display More