+ Reply to Thread
Results 1 to 2 of 2

VBA to transfer image FROM userform image control TO a worksheet cell

  1. #1
    Registered User
    Join Date
    02-01-2013
    Location
    Washington
    MS-Off Ver
    Excel 2010
    Posts
    44

    VBA to transfer image FROM userform image control TO a worksheet cell

    Hello all...

    I am not sure if this can be done, but then again this stuff never ceases to amaze me.

    I have a workbook (which I will attach). This workbook has a userform that the user fills in.

    When they hit the submit button it transfers the data to the workbook... easy enough.

    Also on the userform, I have added the ability for the user to 'choose' up to two images.

    What I am trying to figure out is... how do I get the images transferred to the proper workbook cell like the rest of the data??

    Please don't laugh too much at my coding so far, as I am still really new to all of this. And if it was not for the search ability from this site, and help as well, I probably would have never gotten this far.


    Everything has worked so far, except the picture transfer. I have searched and find tons of stuff to go from the worksheet to the userform, but not the reverse like I am trying to do.

    Again, Thank you for your time.

    Below is the part of the code that is "supposed" to transfer everything to the worksheet... everything works except the image portion.


    Please Login or Register  to view this content.


    And here is the file that I am working with Troubleshooting Guide(sample).xlsm

  2. #2
    Registered User
    Join Date
    02-01-2013
    Location
    Washington
    MS-Off Ver
    Excel 2010
    Posts
    44

    Re: VBA to transfer image FROM userform image control TO a worksheet cell

    ok... so I kept at it, and I have figured out a solution.

    it isn't pretty, but it works... so far.

    since when I grab the images, I have it place the image location into a textbox on the userform, it allowed me to use this and toss in some more script to use the shapes.addpicture option.

    here is what I ended up with, and it places the images properly into my table on the worksheet.

    just in case it might work for someone else.

    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Embed image to button using Image control
    By siobeh in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-12-2014, 05:37 PM
  2. Displaying and Updating Image Dynamically (ActiveX Image Control?)
    By VTHokie11 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-02-2011, 10:57 AM
  3. Image Position within ActiveX Image Control
    By gerryiscool in forum Excel General
    Replies: 0
    Last Post: 09-07-2011, 02:08 AM
  4. Displaying a random image (or control) on a userform?
    By Jon in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-30-2006, 01:25 PM
  5. Userform Image Control and embedded images
    By tim in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 04-05-2005, 09:06 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1