|
楼主 |
发表于 2018-1-11 12:50
|
显示全部楼层
您太客气了,是我求你帮忙,非常感谢。我还有一段代码,有时间帮我合一下,下面的一段他是双击A1也被触发了,而您帮我写的是只需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
复制代码
|
|