ipbr21054
Well-known Member
- Joined
- Nov 16, 2010
- Messages
- 6,007
- Office Version
- 2024
- Platform
- Windows
I have a code in use which works well & i would like to use it again but for a different task.
Currently this is the code in use supplied below.
It check's that the user has double clicked a customer in column A & if so it opens up a userform.
Now i think i need to use the same again code but with an alteration,
Change column 1 for column 2
Change the A8 to B8 & the A for B BUT im stuck on this new part required.
I dont want it to open a form BUT to copy the value in column B & then paste it to cell F7 on the sheet named MCVIN
Currently this is the code in use supplied below.
It check's that the user has double clicked a customer in column A & if so it opens up a userform.
Now i think i need to use the same again code but with an alteration,
Change column 1 for column 2
Change the A8 to B8 & the A for B BUT im stuck on this new part required.
I dont want it to open a form BUT to copy the value in column B & then paste it to cell F7 on the sheet named MCVIN
Rich (BB code):
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
If Target.Column = 1 Then
If Intersect(Range("A8", Cells(Rows.Count, "A").End(xlUp)), Target) Is Nothing Then Exit Sub
Cancel = True
MotorcycleDatabase.LoadData Me, Target.Row
End If
End Sub