Posts by manne.manolov

    Hello,
    I am pretty new to VBA and I need some help with the following issue:


    Sheet 1 contains details info:


    [TABLE="border: 0, cellpadding: 0, cellspacing: 0, width: 432"]

    [tr]


    [td]

    ID

    [/td]


    [td]

    e-mail

    [/td]


    [td]

    phone

    [/td]


    [td]

    details

    [/td]


    [td]

    price

    [/td]


    [td]

    qty

    [/td]


    [/tr]


    [tr]


    [td]

    2

    [/td]


    [td]

    mail 1

    [/td]


    [td]

    phone 1

    [/td]


    [td]

    detail 1

    [/td]


    [TD="align: right"]10.20[/TD]
    [TD="align: right"]1[/TD]

    [/tr]


    [tr]


    [td]

    1

    [/td]


    [td]

    mail 2

    [/td]


    [td]

    phone 2

    [/td]


    [td]

    detail 2

    [/td]


    [TD="align: right"]18.50[/TD]
    [TD="align: right"]5[/TD]

    [/tr]


    [tr]


    [td]

    1

    [/td]


    [td]

    mail 3

    [/td]


    [td]

    phone 3

    [/td]


    [td]

    detail 3

    [/td]


    [TD="align: right"]14.50[/TD]
    [TD="align: right"]145[/TD]

    [/tr]


    [tr]


    [td]

    2

    [/td]


    [td]

    mail 4

    [/td]


    [td]

    phone 4

    [/td]


    [td]

    detail 4

    [/td]


    [TD="align: right"]10.00[/TD]
    [TD="align: right"]12[/TD]

    [/tr]


    [tr]


    [td]

    2

    [/td]


    [td]

    mail 5

    [/td]


    [td]

    phone 5

    [/td]


    [td]

    detail 5

    [/td]


    [TD="align: right"]5.00[/TD]
    [TD="align: right"]18[/TD]

    [/tr]


    [tr]


    [td]

    3

    [/td]


    [td]

    mail 6

    [/td]


    [td]

    phone 6

    [/td]


    [td]

    detail 6

    [/td]


    [TD="align: right"]4.25[/TD]
    [TD="align: right"]20[/TD]

    [/tr]


    [tr]


    [td]

    1

    [/td]


    [td]

    mail 7

    [/td]


    [td]

    phone 7

    [/td]


    [td]

    detail 7

    [/td]


    [TD="align: right"]8.70[/TD]
    [TD="align: right"]25[/TD]

    [/tr]


    [tr]


    [td]

    1

    [/td]


    [td]

    mail 8

    [/td]


    [td]

    phone 8

    [/td]


    [td]

    detail 8

    [/td]


    [TD="align: right"]12.50[/TD]
    [TD="align: right"]20[/TD]

    [/tr]


    [/TABLE]


    Sheet 2 is with IDs:
    [TABLE="border: 0, cellpadding: 0, cellspacing: 0, width: 31"]

    [tr]


    [td]

    ID

    [/td]


    [/tr]


    [tr]


    [td]

    1

    [/td]


    [/tr]


    [tr]


    [td]

    2

    [/td]


    [/tr]


    [tr]


    [td]

    3

    [/td]


    [/tr]


    [tr]


    [td]

    4

    [/td]


    [/tr]


    [/TABLE]


    The issues is:


    With double click on cell from Sheet2 to open ListBox with all data from Sheet1 for the selected cell value
    (if I click on Sheet2(2,1) = 2 to see ListBox with data from Sheet1,where ID = 2)



    I am waiting your replies!
    Best Regards,
    Mitko Manolov