+ Reply to Thread
Results 1 to 2 of 2

Macro Help! Insert picture into cell, based on another cells value

  1. #1
    Registered User
    Join Date
    02-20-2021
    Location
    Dadeville , AL
    MS-Off Ver
    2101
    Posts
    1

    Lightbulb Macro Help! Insert picture into cell, based on another cells value

    So I'm creating a Super Mario themed game / behavior tracker for my kids in Excel.



    I need a macro that when I click on a "? Block" a macro runs that inspects a list of items, PICKS ONE AT RANDOM (important), and inserts the picture correlated with the item name above the ? Block.
    Example:
    Click block > Randomly selects item from the list (1up mushroom) > Opens picture file > Inserts 1up mushroom picture above the ? block




    I've deleted all but a sheet called "Mystery Block", where the kids can click on it once daily to earn a powerup they can use in game like the 1up Mushroom which lets you stay up 30 minutes passed your bedtime.


    I've attached the file if anyone could give it a look and lend a hand. Everything's labeled so you can see what I want.
    The list in from "D84:D182"
    The cell I need the picture inserted is "S20"
    Attached Images Attached Images
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    09-30-2018
    Location
    Vlaams Brabant Belgium
    MS-Off Ver
    365
    Posts
    361

    Re: Macro Help! Insert picture into cell, based on another cells value

    hi,

    try this
    Please Login or Register  to view this content.
    Last edited by Joske920; 02-20-2021 at 06:11 PM.
    Please be as complete as possible in your asking so it may save use all the time to rework the solution because you didn't give all the requirements. If you have a layout in mind please work it out first so we can adapt our solution to it. Thanks.
    If you have been helped, maybe you could click the *

+ 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] Insert picture based on cell value
    By abdumon7 in forum Excel General
    Replies: 2
    Last Post: 11-15-2017, 08:38 AM
  2. [SOLVED] Insert picture based on cell value
    By johandenver in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 10-12-2017, 11:10 AM
  3. [SOLVED] Insert picture based on cell value
    By magman1984 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-19-2015, 10:05 AM
  4. Insert Picture based on Cell Value without Macro
    By greggatz in forum Excel General
    Replies: 2
    Last Post: 03-31-2015, 07:38 PM
  5. Macro to insert picture in cell based off a value in same cell
    By Greybeard84 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-08-2014, 06:36 AM
  6. Insert Picture based on what is typed in Cell?
    By Mile029 in forum Excel General
    Replies: 1
    Last Post: 04-19-2013, 06:10 AM
  7. [SOLVED] macro: insert picture based on workbook location, not picture root path.
    By NicksDad in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-03-2012, 07:47 AM

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