|
[广告] Excel易用宝 - 提升Excel的操作效率 · Excel / WPS表格插件 ★ 免费下载 ★ ★ 使用帮助★
请参考
Dim a(), i
' On Error Resume Next
If (Target.Column = 11 Or Target.Column = 14) And Target.Row > 4 Then
On Error GoTo err
If Target.Validation.Type >= 0 Then SendKeys "%{down}"
End If
err: '自动下拉,不用再点选箭头代码结尾
If Target.Column <> 2 Then Exit Sub
If Target(0, 1) = "" Then Exit Sub
' If Target(1, 0) <> "" Then Exit Sub
If Target.CountLarge = 1 And Target.Row > 4 Then
' If Target(1, 0) = "" Then
If Target.Column = 2 Then Application.CommandBars("myCell").ShowPopup
If Target <> "" Then Target(1, 0) = Date
Target(1, 7) = sx
Target(1, 8).Select
' Target(1, 12) = Lb
' End If
End If
' End If
End Sub |
评分
-
1
查看全部评分
-
|