+ Reply to Thread
Results 1 to 3 of 3

paste images based on cell value

  1. #1
    Forum Contributor
    Join Date
    04-04-2016
    Location
    dallas tx
    MS-Off Ver
    365 (15.0.5501.1000)
    Posts
    541

    paste images based on cell value

    I am creating a cross training matrix for my work. It looks at a persons name and job skill level to paste an image representing there competency level into a cell.
    I have a script that works great. It looks at a cell value and then pastes an image into another cell on another sheet.
    My question is, is there a better way?

    Right now the code is pretty long and it is just working with one row (name) and only a handful of jobs. The completed table will have up to 250 names and maybe 35 individual jobs. It takes three lines of code just to populate one cell, so coding this whole thing will be huge. and I am worried it will lag.

    I have thought about breaking it up into chunks but even doing that will take huge amount of coding.

    Is there a loop or something else that will make this a lot simpler?
    Attached Files Attached Files

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

    Arrow Re: paste images based on cell value


    If the same logic can be applied whatever the row so yes you can use a loop obviously …

  3. #3
    Forum Expert
    Join Date
    05-29-2020
    Location
    NH USA
    MS-Off Ver
    365
    Posts
    2,103

    Re: paste images based on cell value

    You can try something like this. I updated data in the legend worksheet and the Map sheet is populated with information from the Legend sheet. Although I left the merged cells like you have them, it is highly recommended not to use merged cells with vba.

    Please Login or Register  to view this content.
    Last edited by maniacb; 04-12-2023 at 11:10 PM. Reason: Improve code, populate based only on Legend sheet

+ 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. Show images based on a value off a cell
    By andrugrasu in forum Excel General
    Replies: 12
    Last Post: 11-06-2021, 10:47 AM
  2. [SOLVED] Embed images based on linked images.
    By scottiex in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-05-2020, 04:05 AM
  3. Replies: 2
    Last Post: 07-25-2016, 03:39 AM
  4. Copy images in cell based on formula
    By darxide23 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-17-2015, 04:04 PM
  5. [SOLVED] Moving images based on cell value
    By Tortus in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-17-2014, 11:28 AM
  6. Inserting images into a cell based on another cells value.
    By ccScotty in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-04-2012, 12:08 PM
  7. display different images based on cell value?
    By deisenlohr in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-04-2006, 12:00 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