View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ken Johnson Ken Johnson is offline
external usenet poster
 
Posts: 1,073
Default Can you link a graphic in a formual to appear in another cell?

On Apr 27, 7:37 am, dschwei1
wrote:
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