|
发表于 2014-10-23 08:50
|
显示全部楼层
本楼为最佳答案
liwenhong 发表于 2014-10-23 08:24
又一种对想要效果的描述:比如我们先动E2和E3单元格,当E2和E3中都有内容时,在E10中出现“成功1”。此时 ... - Private Sub Worksheet_Change(ByVal Target As Range)
- If (Target.Row = 2 Or Target.Row = 3) And Target.Column = 5 Then
- If Cells(2, 5) <> "" And Cells(3, 5) <> "" Then
- Cells(10, 5) = "成功1"
- End If
- End If
- If (Target.Row = 2 Or Target.Row = 3) And Target.Column = 13 Then
- If Cells(2, 13) <> "" And Cells(3, 13) <> "" Then
- Cells(10, 13) = "成功2"
- End If
- End If
- End Sub
复制代码 楼主试试,是不是这样
|
评分
-
查看全部评分
|