Picture

[Rhgri]

I would like to only show a picture when you select a the cell next to it

 

[Niek Otten]

Look here:

http://www.jkp-ads.com/articles/ShowPicture00.asp

 

[Rhgri]

Thank-you very much!!!

Look here:

http://www.jkp-ads.com/articles/ShowPicture00.asp

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

 

[Chris Bode]

1.Right click on the toolbar>from the popup select control box
2.Select image icon from the control box that appears on the screen an
draw it on the sheet1
3.Select the image box on the sheet>right click>properties
4.In the property dialog box>set visible=false and give pictur
location in picture=
5.Now open code window and paste following codes

Code
-------------------

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Row = 1 And Target.Column = 1 Then
Image1.Visible = True
End If
End Sub

-------------------

the picture will be display on selecting A1 of sheet1


Chris