R
Rhgri
I would like to only show a picture when you select a the cell next to it
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
N
Niek Otten
R
Rhgri
Thank-you very much!!!
Niek Otten said:Look here:
http://www.jkp-ads.com/articles/ShowPicture00.asp
--
Kind regards,
Niek Otten
Microsoft MVP - Excel
C
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
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