What I would need someone to do...is to write a statement in Excel
(like an IF Statement), that would display a specific picture if a
certain #/word/etc is typed in a cell? For example in A1 if I typed in
ball, it would automatically bring up a pic...for example
I have saved of a ball in B1, whereas if I typed dog, it would put a
dog in B1, etc..? If you know how to do this can you PLEASE email me
at as its hard for me to check the Ngs at work...
Thanks in advance
Scott
Please when you respond let me know what youd charge for your help...I
have an important show coming up in 8 days and just have WAY too many
things to do to start learning new code writing. I will send you the
sheet as I have it, and the pictures in an email.

For free!

We don't charge for help on these news groups.

They are peer to peer groups and assistance is voluntary.

See JE McGimpsey's site for a method and a sample workbook.

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


Gord Dibben Excel MVP

On 25 Feb 2005 16:39:43 -0800, wrote:

What I would need someone to do...is to write a statement in Excel
(like an IF Statement), that would display a specific picture if a
certain #/word/etc is typed in a cell? For example in A1 if I typed in
ball, it would automatically bring up a pic...for example
I have saved of a ball in B1, whereas if I typed dog, it would put a
dog in B1, etc..? If you know how to do this can you PLEASE email me
at as its hard for me to check the Ngs at work...
Thanks in advance
Scott
Please when you respond let me know what youd charge for your help...I
have an important show coming up in 8 days and just have WAY too many
things to do to start learning new code writing. I will send you the
sheet as I have it, and the pictures in an email.

This should get you started. You might want to create a worksheet_change
event using select case to pick out different pictures, depending on what
you type in.

Sub InsertPic()
Range("b4").Select
ActiveSheet.Pictures.Insert("C:\yourfolder\toyota xrunner.jpg").Select
With Selection.ShapeRange
'.LockAspectRatio = msoFalse
.Height = 25
.Width = 50
'.Rotation = 0#
End With

End Sub

--
Don Guillett
SalesAid Software

wrote in message
ups.com...
What I would need someone to do...is to write a statement in Excel
(like an IF Statement), that would display a specific picture if a
certain #/word/etc is typed in a cell? For example in A1 if I typed in
ball, it would automatically bring up a pic...for example
I have saved of a ball in B1, whereas if I typed dog, it would put a
dog in B1, etc..? If you know how to do this can you PLEASE email me
at as its hard for me to check the Ngs at work...
Thanks in advance
Scott
Please when you respond let me know what youd charge for your help...I
have an important show coming up in 8 days and just have WAY too many
things to do to start learning new code writing. I will send you the
sheet as I have it, and the pictures in an email.