Hi all,
New to this forum and new to VBA (not another newbie I here you all cry)!
I am self teaching myself to create userform inspection sheets for my quality control procedures in work.
I have a userform that has a textbox where the operator can enter a customer part number and when he hits the command button next to the box I would like the corresponding diagram of the part to be displayed in an image control box on the form to enable better inpection to be done.
In my spreadsheet I have 3 simple columns.
Column A is the part number
Column B is the description
Column C is the full file path for the image on my "C" drive.
If someone could just point me in the general direction of the coding for the click event to load the picture then I am sure I can muddle it through from there.
I am sure something like this has been done before but I just cant seem to find it.
There could be up to 150 seperate part numbers eventually each having its own drawing.
Thanks for any help out there
Nick
Bookmarks