i am stuck please help me

i have this code for excel to make pictures appear when using dropdown list
but it only allows one colum at a time please help see is we can make it work
in more
this is the code :
Public Sub Worksheet_Calculate()
Dim oPic As Picture
Me.Pictures.Visible = False
With Range("A3")
For Each oPic In Me.Pictures
If oPic.Name = .Text Then
oPic.Visible = True
oPic.Top = .Top
oPic.Left = .Left
Exit For
End If
Next oPic
End With
End Sub

I think you will need to provide more details for us. Where are these
pictures supposed to appear at (right now, they only appear over A3)? Do you
have a drop down in A3... is that why the picture is supposed to position
itself there? Are you now asking for other pictures to be allowed to appear
positioned against different cells (where the drop downs are maybe)? If so,
what cells have drop downs in them?

--
Rick (MVP - Excel)


"maydelis" wrote in message
...
i am stuck please help me

i have this code for excel to make pictures appear when using dropdown
list
but it only allows one colum at a time please help see is we can make it
work
in more
this is the code :
Public Sub Worksheet_Calculate()
Dim oPic As Picture
Me.Pictures.Visible = False
With Range("A3")
For Each oPic In Me.Pictures
If oPic.Name = .Text Then
oPic.Visible = True
oPic.Top = .Top
oPic.Left = .Left
Exit For
End If
Next oPic
End With
End Sub

i have three drop down in A2,B2,B3 the pictures are suppose to appear on the
bottom of each dropdown when the iten name is choosen,
thank you


"Rick Rothstein" wrote:

I think you will need to provide more details for us. Where are these
pictures supposed to appear at (right now, they only appear over A3)? Do you
have a drop down in A3... is that why the picture is supposed to position
itself there? Are you now asking for other pictures to be allowed to appear
positioned against different cells (where the drop downs are maybe)? If so,
what cells have drop downs in them?

--
Rick (MVP - Excel)


"maydelis" wrote in message
...
i am stuck please help me

i have this code for excel to make pictures appear when using dropdown
list
but it only allows one colum at a time please help see is we can make it
work
in more
this is the code :
Public Sub Worksheet_Calculate()
Dim oPic As Picture
Me.Pictures.Visible = False
With Range("A3")
For Each oPic In Me.Pictures
If oPic.Name = .Text Then
oPic.Visible = True
oPic.Top = .Top
oPic.Left = .Left
Exit For
End If
Next oPic
End With
End Sub