|
楼主 |
发表于 2018-1-11 13:15
|
显示全部楼层
[广告] VBA代码宝 - VBA编程加强工具 · VBA代码随查随用 · 内置多项VBA编程加强工具 ★ 免费下载 ★ ★ 使用手册★
你太客气了,是我在麻烦你帮忙,太感谢了。我现在有一段代码需与您帮我写的代码合并,您写的是a列触发,而我的这段是A列也被触发了,所以去合在一起,我的这段改为A列不触发。
- '双击工作表单元格的时候调用查询窗口
- Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
- Dim c As Byte
- If ActiveCell.Address(0, 0) = "C3" Then ActiveCell = Date: Exit Sub '双击录入日期
- If ActiveCell.Row > 45 Or ActiveCell.Row < 6 Or ActiveCell.Column > 5 Then Exit Sub
- If Not Range("q4").Value Then Exit Sub '未开启双击单元格查询功能则退出子程序
- Cancel = True '取消双击的默认操作
- With Sheet4
- c = .Range("A1").End(xlToRight).Column
- If c = 256 Then Exit Sub
- ArrCaption = .Range("A1:" & Chr(64 + c) & "1") '再次初始化ArrCaption
- End With
- Select Case ActiveCell.Column
- Case 2, 3, 5
- c = WorksheetFunction.Match(Cells(5, ActiveCell.Column), ArrCaption, 0) '获取列号
- With QueryForm
- .ComboBox1.Text = Cells(5, ActiveCell.Column) '显示查询的列号
- Call FillLvw(.ListView1, c, ActiveCell.Value) '查询
- .Cmd_OK.Enabled = True '使录入按钮可用
- .Show
- InPutRow = ActiveCell.Row
- End With
- Case Else
- QueryForm.Show
- End Select
- End Sub
复制代码
- Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
- If Target.Count <> 1 Then Exit Sub
- If Application.Intersect([a2:a50], Target) Is Nothing Then Exit Sub
- Target.Offset(0, 1).Resize(1, 3).Value = ""
- r = Target.Row
- Cells(r, "g") = ""
- Cells(r, "j") = ""
- Cells(r, "u") = ""
- End Sub
复制代码 |
|