Open Userform1 when double click a row with selected vendor information.

[josros60]

Hi,

how can I modify the the code below when double click open the Userform with information from A:K for that vendor selected right now is opening the form but it's blank.

code:

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)

If Not Application.Intersect(Target, Range("A3:K135")) Is Nothing Then
        UserForm1.Show
    End If

End Sub

Attching sample

Book2
	A	B	C	D	E	F	G
1	SAGEID	VENDOR	INVOICE_NUMBER	PO_NUMBER	APPROVER	GL_CODE	LINE_DESCRIPTION
2	100215	ABC COMM.		17786-28380,28620, 30862	HD	602110-28-500-100 Fixed Data - Customer - Data Services: C - TCOM - ONT	Fixed Data-Customer-Data Services-17786-
3	100109	AFX COMMUNICATIONS		80017	MJT	603202-28-500-100 LD - TF - Other : C - TCOM - ON	LD - TOLL FREE OTHER SERVICES
4	100176	AIRSPRING	162072451	JUNE 2022	HD	603220-28-500-100 LD Toll Dal: C - TCOM - ON	LD - TollDAL-JUNE 2022
5	100384	BEANFIELD METROCONNECT (a/c BF01052205)	90952500	NOV-2021	BF01052205-MJT	602130-28-500-100 Fixed Data - Network - Data Services : C - TCOM - ON	LEGACY DARK FIBRE SERVICES_CIRCUIT # 00085WF101001
6	100053	Allstream Business Inc. C/O T4622	254259-NOV 2021	254259-NOV 2021	254259-JS	603220-28-500-100 LD - Toll DAL : C - TCOM - ON	LD - Toll DAL : C - TCOM - BC - 254259-NOV 2021
7	100053	Allstream Business Inc. C/O T4622	254259-NOV 2021	254259-NOV 2021	254259-JS	323112-08-000-500 HST ITC: G - G - BC	HST NS
8	100053	Allstream Business Inc. C/O T4622	164982-NOV 2021		164982-EK	608110-28-500-100 Fixed Voice - Network - Access & IX : C - TCOM - ON	Fixed Voice - Network - Access & IX BC - 164982-NOV 2021
9	100053	Allstream Business Inc. C/O T4622	164982-NOV 2021	NOV-2021	164982-EK	608110-28-500-100 Fixed Voice - Network - Access & IX : C - TCOM - ON	Fixed Voice - Network - Access & IX BC - 164982-NOV 2021
10	100053	Allstream Business Inc. C/O T4622	164982-NOV 2021	NOV-2021	164982-EK	608110-28-500-100 Fixed Voice - Network - Access & IX : C - TCOM - ON	PST
11	100053	Allstream Business Inc. C/O T4622	164982-NOV 2021	NOV-2021	164982-EK	323112-08-000-500 HST ITC: G - G - BC	GST
12	100053	Allstream Business Inc. C/O T4622	17788676		1139885-EK	605150-28-500-100 Local - Resold - Commercial : C - TCOM - ON	Local - Resold - Commercial - BC-1284630-
13	100053	Allstream Business Inc. C/O T4622	17788676	1139885-NOV 2021	1139885-EK	605150-28-500-100 Local - Resold - Commercial : C - TCOM - ON	PST
14	100053	Allstream Business Inc. C/O T4622	17788676	1139885-NOV 2021	1139885-EK	605150-28-500-100 Local - Resold - Commercial : C - TCOM - ON	Local - Resold - Commercial - BC-1139885-
15	100053	Allstream Business Inc. C/O T4622	17788676	1139885-NOV 2021	1139885-EK	605150-28-500-100 Local - Resold - Commercial : C - TCOM - ON	Local - Resold - Commercial - BC-1139885-EK
16	100072	ANI NETWORKS		100226-10001	HD	603220-28-500-100 LD Toll DAL: C - TCOM ON	LD Toll DAL: C - TCOM BC -FEB 26-MAR 06-2022
17	100226	ARIN		100226	JM	601420-28-500-100 Internet - Other - General Internet Transit : C - TCOM - ON	LEGACY ANNUAL MAINTENANCE
18	100067	AT & T DG (1548) SNET	1866286	NOV-2021	1548-HD	605130-28-500-100 Local&VOIP - Other : C - TCOM - ON	Local&VOIP - Other - Services_SEP 2021
19	100067	AT & T DG (1548) SNET	1866286	NOV-2021	1548-HD	605130-28-500-100 Local&VOIP - Other : C - TCOM - ON	Local&VOIP - Other - Services_SEP 2021
20	100067	AT & T DG (1548) SNET	1866286	NOV-2021	1548-HD	605130-28-500-100 Local&VOIP - Other : C - TCOM - ON	CREDIT-MIDPOINT FUSF BILLE ON:
21	100067	AT & T DG (1548) SNET	1866286	NOV-2021	1548-HD	730011-28-200-100 Bank Charges Expense : C - FD - ON	WIRE FEE
22	100067	AT & T DG (1548) SNET	1866286	NOV-2021	1548-MJT	730015-28-200-100 Late Payment Fee : C - FD - ON	FINANCE CHARGES
23	100125	AT&T (831-000-5480-119,264,269)	CA1000124229	831-000-5481-119-SEP 2022	831-000-5480-119-HD	605130-28-500-100 Local&VOIP - Other : C - TCOM - ON	Local&VOIP - Other - Services_831-000-5480-119-
24	100125	AT&T (831-000-5480-119,264,269)	CA1000124230	831-000-5481-264-SEP 2022	831-000-5480-264-HD	605130-28-500-100 Local&VOIP - Other : C - TCOM - ON	Local&VOIP - Other - Services_831-000-5480-264-
Sheet1

Thank you

 

[josros60]

Any help.