Hi,

I am new to this forum as well as a new user to writing macro in excel VBA.
I appreciate if you can educate me how to work around this need as below...

Lets say I have an Bill of Materials excel sheet with 1 column labeled as Part No. There are 20 parts with different part no in this column, lets say from B3 to B23. At the same time, there are drawings for each of this part no saved in the same folder.

How can I hyperlink all these 20 cells to their respective drawings such that when I move my mouse cursor over this part no and click it, the respective drawing will be automatically pulled out and displayed.

Lets say the excel filename is called "Machine" and the folder is in C:\documents\ProjectA

Thanks,
Vincent

Hi

Can you please have a look at http://vbadud.blogspot.in/2012/02/ho...-multiple.html

Cheers
Shasur

__________________
C# Code Snippets (http://www.dotnetdud.blogspot.com)

VBA Tips & Tricks (http://www.vbadud.blogspot.com)

Thanks for your input, Shasur.

Best regards,
Vincent