dim st as string ,x as long
For x = 1 To 15
If Me.Controls("CheckBox" & x) = True Then st = st & "," & Me.Controls("CheckBox" & x).Caption '选择的数据放入st变量
Next
ActiveCell = Right(st, Len(st) - 1) '粘贴数据到当前选择的单元格
dim st as string ,x as long
For x = 1 To 15
If Me.Controls("CheckBox" & x) = True Then st = st & "," & Me.Controls("CheckBox" & x).Caption '选择的数据放入st变量
Next
ActiveCell = Right(st, Len(st) - 1) '粘贴数据到当前选择的单元格
For x = 1 To 3
If Me.Controls("OptionButton" & x) = True Then st = Left(Me.Controls("OptionButton" & x).Caption, 1) :exit for '截取名字第一个字符并结束循环
Next
If st Like "[A-Z]" Then Application.Intersect(ActiveCell.EntireRow, Columns(st)) = "√" Else MsgBox "名字第一位不为字母" '判断st是否为单个字母, 是 选取当前单元格行和st列共同区域输入值