Macro to insert a photo

[lockers]

Ok guys, I have sorted out my issue with the insert of dates and time but have one that I am really having trouble with.

Firstly the form will be run on a tablet so the less typing the user has to do in the field the better.

I have a form that can be filled out with dropdown boxes and buttons to insert time and date for jobs we undertake. Once we have completed the job/ filled in the form I want a macro/button that allows the insertion of a picture that was taken by the tablet.

I have set up merged cells K15 to Q35 where I would like to insert the photo. I need the macro once clicked to direct you to the folder in the tablet where the photos are located. Once the photo is selected it is then pasted into the merged cell and resizes itself to fit.

If this is at all possible I would greatly appreciate any help.

[JBeaucaire]

This should to it, just edit the picPATH to the default directory to use for the picture selection, edit the GetOpenFilename to the correct filetype, this shows JPG:

Please Login or Register  to view this content.

[lockers]

Thanks for the help worked great. I think it's time for me to start reading up on all the formulas

[JBeaucaire]

I've marked this thread as SOLVED for you.
Next time, select Thread Tools from the links above and mark this thread as SOLVED. Thanks.