Results 1 to 1 of 1

Inserting images into a cell based on another cells value.

Threaded View

ccScotty Inserting images into a cell... 05-04-2012, 12:08 PM
  1. #1
    Registered User
    Join Date
    05-04-2012
    Location
    Whitehouse, Ohio
    MS-Off Ver
    Excel 2010
    Posts
    1

    Inserting images into a cell based on another cells value.

    I found this macro on the web. I use in my spreadsheet now. It's a great program to use and it works well but does anyone know how to make it perform for more than 1 cell at a time? "multiple cells at a time?"
    Private Sub Worksheet_Calculate()
            Dim oPic As Picture
            Me.Pictures.Visible = False
            With Range("F1")
                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
    Last edited by Paul; 05-05-2012 at 04:19 PM. Reason: Added CODE tags for new user. Please do so yourself in the future.

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