+ Reply to Thread
Results 1 to 4 of 4

VBA dynamic picture copying

  1. #1
    Registered User
    Join Date
    05-15-2020
    Location
    https://t.me/pump_upp
    MS-Off Ver
    2020
    Posts
    2

    Post VBA dynamic picture copying

    Hello, Everyone,
    I would like to create a VBA code for copying dynamic pictures. Somehow I need to write a function or sub for copying the pictures and its linked formulas.
    For now I am using image changing with a named range + INDEX/MATCH + linked picture.
    Maybe someone has any ideas how to make it?

  2. #2
    Forum Expert
    Join Date
    11-24-2013
    Location
    Paris, France
    MS-Off Ver
    Excel 2003 / 2010
    Posts
    9,831

    Arrow Re: VBA dynamic picture copying


    Hi,

    what clearly means « dynamic pictures » under Excel ?!

    Elaborate « pictures and its linked formulas » …
    As using formulas you may not ever need any VBA procedure.

    You can activate the Macro Recorder and copy manually some 'dynamic' picture : you will get your own code base …

  3. #3
    Registered User
    Join Date
    05-15-2020
    Location
    https://t.me/pump_upp
    MS-Off Ver
    2020
    Posts
    2

    Re: VBA dynamic picture copying

    Dynamic picture -> it inserts or changes the picture based on cell value. If there is a need to copy it, to have severeal pictures, I would like to make it in one button click.
    Now it only works as picture Lookup.

  4. #4
    Forum Expert
    Join Date
    11-24-2013
    Location
    Paris, France
    MS-Off Ver
    Excel 2003 / 2010
    Posts
    9,831

    Arrow Re: VBA dynamic picture copying


    If the picture comes as a result of a formula so 'to copy' just use a formula.

    If you think this formula way is not possible, just use the Macro Recorder and operate manually a copy to get a code base …

+ 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. Dynamic Picture Viewer
    By Saighead in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-06-2019, 09:46 AM
  2. Dynamic Picture Viewer
    By praveen.991 in forum Excel General
    Replies: 1
    Last Post: 04-11-2013, 10:22 AM
  3. dynamic picture embedding
    By addysdddy in forum Excel General
    Replies: 5
    Last Post: 06-14-2012, 10:25 AM
  4. copying a picture in a cell
    By Soundman in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-27-2006, 10:55 AM
  5. Replies: 0
    Last Post: 02-28-2006, 09:10 PM
  6. Replies: 0
    Last Post: 02-28-2006, 09:10 PM
  7. Replies: 0
    Last Post: 02-28-2006, 09:10 PM

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