I have six option buttons and a combo box on a form. Depending on which option button is selected would determine what gets populated inside the combobox. All combobox values for each option button pulls values from a spreadsheet. As of now, if the user accidentally selects the wrong option...
Private Sub cmbPrdCde_Enter()
Dim ary As Variant, nary As Variant, r As Long
If cmbSDPFLine.Value = "Slat" Then
cmbPrdCde.Value = ""
ary = .Range("B3", .Range("B" &...