|
发表于 2011-7-30 14:16
|
显示全部楼层
本楼为最佳答案
代码如下:
- Public i As Long
- '声明全局变量i
- Sub Input_()
- If Selection.Column = 1 And Selection.Count = 3 Then
- '判断选取的是不是第1列并且单元格个数为3
- If Cells(Selection.Row, "B") <> "" Then
- '判断所选的B列中是不是有数据
- If MsgBox("B" & Selection.Row & "中有数据,是否输入?", vbYesNo, "提示") = vbYes Then
- '判断弹出的提示框所选择是:“yes 还是 no”
- i = i + 1
- '变量每运行一次则就在自身上加1
- Cells(Selection.Row, "A") = i
- '所选的A列中输入值i
- Cells(Selection.Row, "C") = i
- '所选的C列中输入值i
- End If
- Else
- i = i + 1
- Cells(Selection.Row, "A") = i
- Cells(Selection.Row, "C") = i
- End If
- End If
- End Sub
复制代码
附件:
问题.rar
(7.7 KB, 下载次数: 71)
|
|