Help with Pictures on Userform

Hi,

I'm trying to setup a userform that would display pictures pulled from my computer based on a look up value from a combox value. The combo box is Named "cboSKU", I'm encountering two issues with my code.

1. I want the picture to auto update when i enter the combo box value, currently I have to click the image box to get the picture loaded.
2. When the file is found it takes a very long time to load.
3. If there isn't any picture found, I want it to just print "Picture Not Found" in the image box, but can't get it to work. My code now is setup to show an message box but that doesn't either work.

I can't attach a file due to sensitive information, However here is the code.

Please Login or Register  to view this content.

I'm a newbie to VBA, but a quick learner.
Thanks for any assistance.

Thanks for the quick reply, The change event was crashing to quickly, i changed the first line to AfterUpdate which solved that problem. The pictures load much quickly however the error handling is still not fixed. It gives me the build in VBA error
"Runtime Error '53':
File Not Found
Here is the updated code I used:

Please Login or Register  to view this content.

Thanks

Thanks it removed the errors messages but just leaves the old picture there without clearing it or displaying the message box. I can manage with that!
As a side question, I wouldn't mind streamlining my code, can you define one set error handling for the Form or each separate sub needs it's own error handling?
Thanks