Results 1 to 4 of 4

Hiding / unhiding pictures based on cell value

Threaded View

  1. #2
    Forum Expert
    Join Date
    07-15-2012
    Location
    Leghorn, Italy
    MS-Off Ver
    Excel 2010
    Posts
    3,431

    Re: Hiding / unhiding pictures based on cell value

    I can't find object pictures, you can try something like
        Private Sub Worksheet_Calculate()
    
            Dim oPic As Shape
            With Worksheets("Quiz").Range("L2")
                For Each oPic In Me.Shapes
                    If oPic.Name = .Text Then
                        oPic.Visible = True
                        oPic.Top = .Top
                        oPic.Left = .Left 'Right
                        Exit For
                    End If
                Next oPic
            End With
        End Sub
    Last edited by patel45; 08-14-2012 at 12:19 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1