Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can you link a graphic in a formual to appear in another cell?
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can you link a graphic in a formual to appear in another cell?
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 On Sun, 27 Apr 2008 06:01:54 -0700 (PDT), Ken Johnson wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
A cell visable on a graphic | Excel Discussion (Misc queries) | |||
Has anyone tried to link cells in a spreadsheet to a graphic? | Excel Discussion (Misc queries) | |||
Can I add a graphic to a cell in Excel | Excel Worksheet Functions | |||
Insert & link a graphic file in Excel 2003 -- updatable pictures! | Excel Discussion (Misc queries) | |||
Insert a graphic in a cell | Excel Discussion (Misc queries) |