Hi All,

The set-up: as part of my research, I have a datasheet in Excel for
collecting morphological measurements, (a made-up example described below):

A B C D E F
1 Bob Mary Jane Chuck Etc.
2 Big Toe Width
3 Big Toe Length
4 Height
5 Arm Span
6 Etc.

My sheet has ~100 measurements (column A) and the number of individuals to
be measured per worksheet will vary. I am lucky enough to have a measuring
tool which inputs directly to the computer & enters data a click of a button.
Thus, if I started measuring Bob at cell B2, each click would send the cursor
down one cell (to B3, then B4, etc.). Very handy!

The question(s): While in each cell, I would like the option of having one
or two things happen. First, (and most importantly), for people who know
exactly how to take the measurements, but can't keep track of the order they
are supposed to measure & don't want to keep looking up at the computer
screen, I would like the option to utilize the text-to-speech functionality
of Excel (as a last resort, perhaps have an audio clip play). Thus, when the
cursor moved to any cell in row 2, Excel could speak the text in cell A2
("big toe width"), when the cursor jumps to any cell in row 3, Excel could
speak the text in A3 ("big toe length"), etc. Second, since a variety of
people may take these measurements (not just me), I would like the option to
display a picture (showing exactly where to take the measurements). So, when
the cursor moved to any cell in row 2, a picture could display showing
exactly how to measure big toe width (row 3 would have a picture of how to
measure big tow length, and so on).

I have read about changing a cell's Comment to display an image, but given
that I have 100 measurements & will end up with 1000 individuals, I'd rather
not change 100,000 cell Comments. Perhaps just some code of with a dynamic
range...? Finally, my automatic measurement input tool needs Excel to be
active for data to come across. Thus, not sure of the potential solutions on
how the image might get called up if not in Excel (i.e. via Microsoft Paint
or Internet Explorer), but no matter which software, the Excel spreadsheet
must remain/end up as the active window. Hopefully all of this has made
sense.

I am running Excel/Office 2003 on Windows XP. Again, the first half of the
question (text-to-speech on a distant cell) is the most important. Thanks for
any ideas, suggestions, and code you might have,

Chris