Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old June 3rd 09, 02:46 AM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Jun 2009
Posts: 1
Default insert an image based on a cell value

i am trying to create a model of genetics within a spreadsheet where the
male and female genetic contribution to their offspring is displayed in a
cell either as A or a and using " &" to conbine in the offspring cell ,
chromosmes are displayed as AA,Aa or aa is it possible ....ifor this
resultant cell content to then control an image to be viewed to show the
shape of the offspring with that resultant genetic code.....eg IF cell
content =AA 2 antennae / Aa 1 antenna / and aa 0 antenna
i have a very basic drawing created but i would like to import better ,
specific image files i have created to show the resultant body parts etc from
the genetic code .
my aim is tp use a smartboard in a classroom setting and the pupils would
randomly choose the male / female contribution which would show the effect on
the offspring and the resultant offspring can be compared.....primarily
typing in the male / female contributions but what i would like would be for
them to touch the smartboard to select the male /female chromosomes to make
this selection ..
maybe a tad overambitious as my spreadsheet knowledge is limited and any
other program knowledge is non existant so i would need solution to be idiot
proof

many thanks


  #2   Report Post  
Old June 3rd 09, 07:10 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 5,441
Default insert an image based on a cell value

Take a look at my file he

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

Look for

DV0049 - ClipArt Selection -- Select a clipart item from a data validation dropdown list, and that
picture appears in the adjacent cell. Uses Worksheet_Calculate event code. Sample file from Bernie
Deitrick. ClipArtEvent.zip 30kb 03-Jun-07

HTH,
Bernie
MS Excel MVP


"brig239" wrote in message
...
i am trying to create a model of genetics within a spreadsheet where the
male and female genetic contribution to their offspring is displayed in a
cell either as A or a and using " &" to conbine in the offspring cell ,
chromosmes are displayed as AA,Aa or aa is it possible ....ifor this
resultant cell content to then control an image to be viewed to show the
shape of the offspring with that resultant genetic code.....eg IF cell
content =AA 2 antennae / Aa 1 antenna / and aa 0 antenna
i have a very basic drawing created but i would like to import better ,
specific image files i have created to show the resultant body parts etc from
the genetic code .
my aim is tp use a smartboard in a classroom setting and the pupils would
randomly choose the male / female contribution which would show the effect on
the offspring and the resultant offspring can be compared.....primarily
typing in the male / female contributions but what i would like would be for
them to touch the smartboard to select the male /female chromosomes to make
this selection ..
maybe a tad overambitious as my spreadsheet knowledge is limited and any
other program knowledge is non existant so i would need solution to be idiot
proof

many thanks





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Insert a value in a cell based upon a comparison of cell values in 2 separate worksheets Doctorjones_md Excel Discussion (Misc queries) 7 June 8th 07 09:32 PM
Insert a value in a cell based upon a comparison of cell values in 2 separate worksheets Doctorjones_md Excel Worksheet Functions 7 June 8th 07 09:32 PM
How can I insert an image inside a comment of a cell? Javigir Excel Discussion (Misc queries) 1 February 1st 07 12:03 PM
How do i insert a image to a single cell then click on the cell & Geek Setting up and Configuration of Excel 1 April 28th 06 03:46 AM
How do I insert an image into a specific cell within a protected . Scott Peebles Excel Discussion (Misc queries) 1 January 7th 05 01:14 AM


All times are GMT +1. The time now is 01:10 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017