+ Reply to Thread
Results 1 to 5 of 5

Insert Image to adjacent cell, not predefined cell

  1. #1
    Registered User
    Join Date
    01-11-2010
    Location
    USA
    MS-Off Ver
    2010
    Posts
    48

    Insert Image to adjacent cell, not predefined cell

    The following code opens a window, allows you to select an image, and then inserts it into a predefined range (B6 in this case). Instead of predefining a range, I need it to insert the image to the cell "range" one cell to the right of the button. For example, If the button is in A1, I want it to insert the image into Range("B1"). The button is a Form Control button and it resides on cell to the left of where the image should go.

    Suggestions? Any help would be greatly appreciated!

    Please Login or Register  to view this content.
    Last edited by tshrader; 04-02-2013 at 10:59 AM.

  2. #2
    Registered User
    Join Date
    01-11-2010
    Location
    USA
    MS-Off Ver
    2010
    Posts
    48

    Re: Insert Image to adjacent cell, not predefined cell

    I updated the original post because I figured out two of the three items. I'm still struggling with the one. Any help would be so great. Thanks in advance!

  3. #3
    Registered User
    Join Date
    01-11-2010
    Location
    USA
    MS-Off Ver
    2010
    Posts
    48

    Re: Insert Image to adjacent cell, not predefined cell

    bueller... anyone... anyone

  4. #4
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,419

    Re: Insert Image to adjacent cell, not predefined cell

    Please Login or Register  to view this content.
    Cheers
    Andy
    www.andypope.info

  5. #5
    Registered User
    Join Date
    01-11-2010
    Location
    USA
    MS-Off Ver
    2010
    Posts
    48

    Re: Insert Image to adjacent cell, not predefined cell

    Beautiful, thanks, Andy! Works like a charm

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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