Excel Userform - Image field which loads to worksheet First of all... I am a total beginner, but think I am 80% done with my goal, but 80 might as well be 0.
I have created a userform to input data into my worksheet. I have 8 fields which populate my worksheet. On my userform I have an 'Add Data' button which works like a charm via a tutorial from contextures.com
On each row on my worksheet I would like there to be a product image. How do I add an input field on my userform that will allow the user to point to an image file and in essence be my 9th field on my worksheet? I have tried creating a button using the getopenfilename along with other commands for this button but nothing I have tried comes close to achieving my goal.
Can anyone explain to me how I can accomplish this. So, my goal is for the user to select a photo as one of the fields that will populate my spreadsheet. Also, if this can be achieved can I set an image size for this item. Needs to be a little bigger than a thumbnail.
Thank you for listening,
northgreen |