+ Reply to Thread
Results 1 to 4 of 4

How to a insert new picture excel

  1. #1
    Registered User
    Join Date
    03-31-2017
    Location
    London
    MS-Off Ver
    2010
    Posts
    2

    How to a insert new picture excel

    I found the attached excel file could not insert a new picture on the list.

    Is it hide up the pictures?
    how can I insert more pictures with the picture's name?

    Option Explicit

    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
    Attached Files Attached Files

  2. #2
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: How to a insert new picture excel

    Paste new picture with correct size
    Add new entry to the table, eg. John Picture 5
    Change table range to: =Sheet2!$A$2:$B$6
    Go to selection Pane and change the picture name to Picture 5

    btw. I didn't touch VBA code
    Attached Files Attached Files
    Last edited by sandy666; 03-31-2017 at 03:47 AM.

  3. #3
    Registered User
    Join Date
    03-31-2017
    Location
    London
    MS-Off Ver
    2010
    Posts
    2

    Re: How to a insert new picture excel

    Thanks your reply
    in the attached file why there is. No existing name of corresponding pictures?

  4. #4
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: How to a insert new picture excel

    I open attached file and I don't see any No existing name of corresponding pictures
    Add picture by yourself because you've Ex2003, I don't.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] insert picture the same size and location of existing picture
    By mcdermott2 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-13-2015, 11:14 AM
  2. VB code to insert picture when email picture not in excel
    By T_BOLT in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-07-2014, 06:42 AM
  3. VBA for Picture insert at particular worksheet range. Picture name derived from cell.
    By Douglas2013 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-09-2013, 01:16 AM
  4. Creating macro to insert a picture by including specific picture name & path
    By NissaFrenchRamsteyn in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-09-2012, 05:40 AM
  5. Insert and Keep Picture in Excel
    By QUICKJ in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-28-2012, 02:38 PM
  6. [SOLVED] macro: insert picture based on workbook location, not picture root path.
    By NicksDad in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-03-2012, 07:47 AM
  7. [SOLVED] How do I put a picture in excel with out using insert?
    By RFCahoon in forum Excel General
    Replies: 4
    Last Post: 07-16-2005, 11:05 PM

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