Will pay someone to write small event code for me!!

[ratedr1]

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 (e-mail address removed) 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.

 

[Gord Dibben]

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

 

[Don Guillett]

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