pick by screen -issue with IF statement

Hi Guys,

I'm working on small excel programm which Can shows pictures depends on if statement,for example I have table in sheet DATA:


item comp no
1 Box 010
1 Box 020
1 Box 030
1 Label 050
1 Label 060
2 Box 010
2 Box 020
2 Label 050
2 Label 060
2 Label 070

Mcode:

Please Login or Register  to view this content.

My code shows texts in box1 box2 box3 etc but It also shows text from 4th row.
I would like to show just Cells(i, 3) in boxs when Worksheets("DATA").Cells(i, 1) And Worksheets("DATA").Cells(i, 2) = "Box"

I really can't go thru it

Could you help me?

thank you

Hi

Can you put up an example file with some data, the comboboxes and your code so we can review.

ryo

I have attached file.When I type in item number in item textbox I would like to shows in images all pictures of components from this item number.

thank you for replay

Can Anyone help me?

I will be really appreciate

Hi

Shouldn't

Please Login or Register  to view this content.

be

Please Login or Register  to view this content.

BOXTOP is only 6 characters long, and from your example file BOXTOP appears in column H which is column 8

rylo

yyeep.
I had to remove personal data from table.I forgot to change value from 13 to 6.
Any idea how to to fix it?

Hi

If the changes to the formula don't fix your problem, update the example file, and the code in that file and reattach.

rylo