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:
Attching sample
Thank you
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:
VBA 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