Doubleclick

  • Thread starter Thread starter KalliKay
  • Start date Start date
K

KalliKay

On sheet Vendor_Info I have an external data query which returns the
following data from cash management for a specified time period:
Vendor ID
Vendor Name
Check #
Check Amount

I want to be able to doubleclick on one check number from sheet Vendor_Info
and have it copied on to sheet Vendor_Chk_Info in cell C4...which is a
parameter for another query. I would appreciate assistance with this.
Thanks.
 
will this event code help you ?????

right click the first sheet and click view code
type this code

Code: 
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
Cancel = True
If Target.Column <> 3 Then Exit Sub
Target.Copy Worksheets("sheet2").Range("C4")

End Sub

I am calling the second sheet as sheet2 . make necessary changes in the code about your sheet name
 
Back
Top