Excel_User_10k
Board Regular
- Joined
- Jun 25, 2022
- Messages
- 100
- Office Version
- 2021
- Platform
- Windows
Hi All, I have several Radio button selections as part of an Order form.
Radio Button A Options - Yes (1), No (2)
Radio Button B Options - Yes (1), No (2), N/A (3)
Radio Button C Options - Yes (1), No (2), N/A (3)
If Radio A is selected as No, then B and C are not applicable. Rather than having to Manually Select N/A on both Radio buttons B and C, I want them to Automatically go to N/A when Radio A > No is selected. I know this cannot be done with Formula's, as they would just be cleared when another option is selected. So I am trying to figure it out with VBA. So far I have:
I feel like I am close. But at the moment, nothing is happening. Please can you tell me what I am missing and fill in the missing code?
Thank You
Radio Button A Options - Yes (1), No (2)
Radio Button B Options - Yes (1), No (2), N/A (3)
Radio Button C Options - Yes (1), No (2), N/A (3)
If Radio A is selected as No, then B and C are not applicable. Rather than having to Manually Select N/A on both Radio buttons B and C, I want them to Automatically go to N/A when Radio A > No is selected. I know this cannot be done with Formula's, as they would just be cleared when another option is selected. So I am trying to figure it out with VBA. So far I have:
VBA Code:
Sub Radio_Button()
If .Cells(13, 11) = 2 Then
.Cells(13, 3) = 3
.Cells(13, 7) = 3
End
End Sub
I feel like I am close. But at the moment, nothing is happening. Please can you tell me what I am missing and fill in the missing code?
Thank You