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"
Bookmarks