Can you link a graphic in a formual to appear in another cell?

[dschwei1]

I am a School Technology Resource teacher. I work with classroom teachers
to intergrate technology in their classrooms. I have directions on how to
make bingo cards using excel and it works great with word to produce 25 to 30
different cards. My problem is preschool though 2 grade like to use pictures
or graphics.

Is there a way to put the graphics on one sheet and using a formula make
them appear in the cell of another sheet. I now we can copy and paste, and
we have done that. But Part of what made this project great is if you
changed the word it changed on all te bingo cards. So if You could hook it
to a formual when you change te shape in one cell it changes in all the
linked cells.

Can this be done?

 

[Ken Johnson]

I am a School Technology Resource teacher. I work with classroom teachers
to intergrate technology in their classrooms. I have directions on how to
make bingo cards using excel and it works great with word to produce 25 to 30
different cards. My problem is preschool though 2 grade like to use pictures
or graphics.

Is there a way to put the graphics on one sheet and using a formula make
them appear in the cell of another sheet. I now we can copy and paste, and
we have done that. But Part of what made this project great is if you
changed the word it changed on all te bingo cards. So if You could hook it
to a formual when you change te shape in one cell it changes in all the
linked cells.

Can this be done?

Hi,

That would require VBA code to control the visibility of pictures on
the sheets. Pictures aren't in cells, they sit over the sheet's
surface.

Look here for an example of how VBA code is used to do this...

http://www.mcgimpsey.com/excel/lookuppics.html

Of course, if you are wanting a picture version of the bingo workbook
you already have it would most likely require a lot of code
modification.

If I could see your workbook I could have a go at it, could be fun.
Feel free to email the workbook to me (email in profile) if you get
stuck.

Ken Johnson

 

[Gord Dibben]

In addition to Ken's suggestion of John's lookuppics which is limited to one
picture at a time you could download Bernie Dietrick's sample workbook which
allows for more than one picture to be shown.

http://www.contextures.on.ca/excelfiles.html#DataVal

DV0049 - ClipArt Selection

Edit the code to suit.


Gord Dibben MS Excel MVP