Results 1 to 4 of 4

Thread: Embed image into workbook through userform?

  1. #1

    Thread Starter
    New Member
    Join Date
    Oct 2017
    Posts
    5

    Embed image into workbook through userform?

    Good morning,

    Using Excel 2010 VBA, MS Windows 7 Enterprise 64 bit, MS Office 2010 32 bit.

    Is there a way to embed an image into a userform? I'm building an inventory audit userform and would like to have the user take a photo, transfer it to the laptop, and then embed the photo into the workbook through the userform.

    Thanks,
    Karmadog in Austin

  2. #2
    Super Moderator si_the_geek's Avatar
    Join Date
    Jul 2002
    Location
    Bristol, UK
    Posts
    41,929

    Re: Embed image into workbook through userform?

    Thread moved from the 'VB.Net' forum to the 'Office Development/VBA' forum.

  3. #3
    PowerPoster
    Join Date
    Dec 2004
    Posts
    25,618

    Re: Embed image into workbook through userform?

    do you want the photo in the userform and the workbook?
    i am sure there is no reason why this can not be done

    you are just going to copy the photo into some folder on the laptop first? or you need to locate the photo on some other device?
    better if you can give some more details, possibly a sample workbook, with userform (zip first) to demonstrate the desired result
    i do my best to test code works before i post it, but sometimes am unable to do so for some reason, and usually say so if this is the case.
    Note code snippets posted are just that and do not include error handling that is required in real world applications, but avoid On Error Resume Next

    dim all variables as required as often i have done so elsewhere in my code but only posted the relevant part

    come back and mark your original post as resolved if your problem is fixed
    pete

  4. #4

    Thread Starter
    New Member
    Join Date
    Oct 2017
    Posts
    5

    Re: Embed image into workbook through userform?

    Yes, I'd like the image embedded in the worksheet and also in the userform for the end user to view. The end user will take a photo with a phone and then transfer the photo to the laptop. Since the end user will only see the userform, I wanted the photo to be viewed in the userform, and also embedded in the workbook so that he can send me the saved workbook without having to send the separate picture file.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width