Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Making visible a picture
Hi to all;
I need to do the following: If a cell value is zero, a picture must appear. But if this cell's value is different than zero; this picture has to disappear. How can I do this? Suppose I want to do this without clicking any button, only changing the cell value. Is it possible? Thanks to all; -- atrep |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Making visible a picture
Right click the sheet where you want this to happen and select View
Code. Then use something like below. Private Sub Worksheet_Change(ByVal Target As Range) If Range("A15").Value = 0 Then ActiveSheet.Shapes(1).Visible = True Else ActiveSheet.Shapes(1).Visible = False End If End Sub xavi garriga wrote: Hi to all; I need to do the following: If a cell value is zero, a picture must appear. But if this cell's value is different than zero; this picture has to disappear. How can I do this? Suppose I want to do this without clicking any button, only changing the cell value. Is it possible? Thanks to all; -- atrep |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I insert picture into cell so vlookup can return picture? | Excel Worksheet Functions | |||
Making a form visible | Excel Discussion (Misc queries) | |||
insert a picture in to a comment but picture not save on hard disk | Excel Discussion (Misc queries) | |||
making only specified columns visible | Excel Discussion (Misc queries) | |||
Autoshapes not visible on spreadsheet but visible in print preview | Excel Discussion (Misc queries) |