Macro Help! Inserting picture based on random cell value

%3CLINGO-SUB%20id%3D%22lingo-sub-2152031%22%20slang%3D%22en-US%22%3EMacro%20Help!%20Inserting%20picture%20based%20on%20random%20cell%20value%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2152031%22%20slang%3D%22en-US%22%3E%3CP%3ESo%20I'm%20creating%20a%20Super%20Mario%20themed%20game%20%2F%20behavior%20tracker%20for%20my%20kids%20in%20Excel.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20need%20a%20macro%20that%20when%20I%20click%20on%20a%20%22%3F%20Block%22%20a%20macro%20runs%20that%20inspects%20a%20list%20of%20items%2C%20picks%20one%20at%20random%2C%20and%20inserts%20the%20picture%20correlated%20with%20the%20item%20name%20above%20the%20%3F%20Block.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EThere's%20a%20sheet%20called%20Mystery%20Block%2C%20where%20the%20kids%20can%20click%20on%20it%20once%20daily%20to%20earn%20a%20powerup%20they%20can%20use%20in%20game%20(Example%3A%20Red%20Mushroom%20lets%20you%20stay%20up%2030%20minutes%20passed%20their%20bedtime)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI've%20attached%20the%20file%20if%20anyone%20could%20give%20it%20a%20look%20and%20lend%20a%20hand.%20Everything's%20labeled%20so%20you%20can%20see%20what%20I%20want.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2152031%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3Edeveloper%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

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, and inserts the picture correlated with the item name above the ? Block. 

 


There's a sheet called Mystery Block, where the kids can click on it once daily to earn a powerup they can use in game (Example: Red Mushroom lets you stay up 30 minutes passed their 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.

 

 

 

0 Replies