Hyperlink Help

[thanigan]

I have a list of Part Numbers that is 400+ parts long. I have pictures corresponding to each part number. I have a macro that searches for the numbers in the first row and opens the link in the 3rd. I want to copy the number in the first row and create a link to the picture that has the same file name as a .jpg. The numbers are not sequencial and I included a short sample of the number I'm working with to give you an idea.

35214
35616
35727
36481
37984
38237
38625
38636
38711
39100
39113
39115
39116
39127
39130
39138
39152
39155
39898
39899
39982
39983

If you have any ideas or suggestions let me know.

[rpicilli]

Hi There!

When you say "in the first row" are you talking about a Database, a spreadsheet, or?

If you put your Macro, may be this help us to help you.

I understand the the picture has the same name of your "code" with a jpg extention.

You could create a form with a Listbox where you fill up with your "code". As the user select a line into the listbox, your could capture the Text property, add the ".jpg" to the text and open up the image file into a Picturebox.

I hope this help you.

Rpicilli