+ Reply to Thread
Results 1 to 6 of 6

VBA code for reference cell for image

  1. #1
    Forum Contributor
    Join Date
    11-24-2019
    Location
    India
    MS-Off Ver
    Ms. Office 2016
    Posts
    174

    VBA code for reference cell for image

    Hello,
    I want to reference image inserted at one place in the sheet to various sheets, so that if i change or delete original image then link images will be changed accordingly.
    As i know, in case of text or numbers, reference cell is possible by showing '=A1' to other cells. But i do not know how to create reference link for images.

    Please provide vba code so that i can automatically update reference cell image.

    Thanks.

  2. #2
    Forum Expert
    Join Date
    10-06-2008
    Location
    Canada
    MS-Off Ver
    2007 / 2013
    Posts
    5,719

    Re: VBA code for reference cell for image

    Please Login or Register  to view this content.

  3. #3
    Forum Contributor
    Join Date
    11-24-2019
    Location
    India
    MS-Off Ver
    Ms. Office 2016
    Posts
    174

    Re: VBA code for reference cell for image

    hello ,
    thanks but it is not working,
    i have attached sheet, e.g. i have image in sheet 1 at A1 cell and i want to make its link reference to sheet2 B2 cell. So that whenever i will change sheet1 image, sheet2 image will get change automatically without keeping old/extra image.
    Attached Files Attached Files

  4. #4
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,524

    Re: VBA code for reference cell for image

    I find it hard to follow your explanation.

    You do not have an image in sheet 2.

  5. #5
    Forum Contributor
    Join Date
    11-24-2019
    Location
    India
    MS-Off Ver
    Ms. Office 2016
    Posts
    174

    Re: VBA code for reference cell for image

    Yea sheet 2 don't have image. But i want to link image of sheet 1.
    I know linking about text or number through reference cells by =A1 but don't know about image.

  6. #6
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,524

    Re: VBA code for reference cell for image

    I was hoping your sample workbook would having given some indication of what you were asking.

+ 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. want to reference code from table if cell contains text that has the code in it
    By dtrinhexcel in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-18-2019, 07:36 PM
  2. vba - Export cell range to image on desktop! Help with code
    By ironfelix717 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-15-2017, 06:33 AM
  3. Search box code - Will display an image and clear to remove image
    By mutzie in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-06-2016, 11:10 AM
  4. Code to paste image from filename into cell that is referenced?
    By ChristophExcel in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-20-2014, 01:32 PM
  5. [SOLVED] Code to copy data in cell, but not image over cell.
    By Nitefox in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 7
    Last Post: 10-02-2013, 12:52 AM
  6. Setting Image Properties with Cell Reference
    By bfvba in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-04-2012, 09:05 AM
  7. How to embed an image in a cell by URL reference?
    By jason-w in forum Excel General
    Replies: 4
    Last Post: 09-22-2011, 04:49 PM

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