Private Sub CommandButton1_Click()
Range("A65536").End(3)(2) = ComboBox1
For I = 1 To 3 '循环检查选项
If Controls("OptionButton" & I) = True Then '若被选中
Range("A65536").End(3).Offset(0, 1) = Controls("OptionButton" & I).Caption
'A列最后一单元的右一列单元填上选项的标识
Exit For '退出循环
End If
Next
For I = 1 To 3 '循环检查复选项
If Controls("CheckBox" & I) = True Then '若被选中
t = t & " 、" & Controls("CheckBox" & I).Caption '选项的标识赋给变量
End If
Next
If t = "" Then Exit Sub '若没有被选中,则退出
Range("A65536").End(3).Offset(0, 2) = Right(t, Len(t) - 2)
'变量除去前面的空格和“、”,填入A列最后一单元的右第2列单元
End Sub
Private Sub CommandButton2_Click()
Unload Me '退出窗体
End Sub
Private Sub UserForm_Initialize()
ComboBox1.List = Array("男", "女") 'ComboBox1赋值
End Sub