Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Picture
I would like to only show a picture when you select a the cell next to it
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Picture
Look he
http://www.jkp-ads.com/articles/ShowPicture00.asp -- Kind regards, Niek Otten Microsoft MVP - Excel "Rhgri" wrote in message ... I would like to only show a picture when you select a the cell next to it |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Picture
Thank-you very much!!!
"Niek Otten" wrote: Look he http://www.jkp-ads.com/articles/ShowPicture00.asp -- Kind regards, Niek Otten Microsoft MVP - Excel "Rhgri" wrote in message ... I would like to only show a picture when you select a the cell next to it |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Picture
1.Right click on the toolbarfrom the popup select control box 2.Select image icon from the control box that appears on the screen and draw it on the sheet1 3.Select the image box on the sheetright clickproperties 4.In the property dialog boxset visible=false and give picture 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 ------ Convert your Excel spreadsheet into an online calculator. http://www.spreadsheetconverter.com -- Chris Bode |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Inserting a Picture using Cell as picture name. | Links and Linking in Excel | |||
how do I insert picture into cell so vlookup can return picture? | Excel Worksheet Functions | |||
insert a picture in to a comment but picture not save on hard disk | Excel Discussion (Misc queries) | |||
How do I put single picture into Picture it from a disk? | New Users to Excel | |||
How to extract a picture from an Excel worksheet into a picture fi | Excel Discussion (Misc queries) |