Hello All.
I have a piece of code i am using.
I would like to use the double click function to detect which cell i have selected and open a userform i have with the cells value as preferably a Label if not possible a text box.
To keep things simple i will use userform1 and label1 for examples.
I would like to keep the process of copying and pasting the value into the cell if possible, unless there is a simpler way without using copy/paste that anyone can suggest
Thankyou for any help you can give.
I have a piece of code i am using.
Code:
Private Sub worksheet_beforedoubleclick(ByVal target As Range, Cancel As Boolean) If Not Intersect(target, Range("B5:B50")) Is Nothing Then
Selection.copy
Sheets("Masster").Select
Sheets("Master).Range("A2").PasteSpecial xlPasteValues
End If
End Sub
To keep things simple i will use userform1 and label1 for examples.
I would like to keep the process of copying and pasting the value into the cell if possible, unless there is a simpler way without using copy/paste that anyone can suggest
Thankyou for any help you can give.