+ Reply to Thread
Results 1 to 3 of 3

vba import picture change shape to rectangle

  1. #1
    Registered User
    Join Date
    04-01-2014
    Location
    Kansas City, US
    MS-Off Ver
    Excel 2007
    Posts
    10

    vba import picture change shape to rectangle

    I already have the code to import the picture but i would like it to have rounded corner's. The option if you select the picture then tick format, picture shape and it's the second rectangle in. I can not seem to find that particular piece of code for that particular shape. The other comparison is the (reflected beveled, black) option under picture format.

    Please Login or Register  to view this content.

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,461

    Re: vba import picture change shape to rectangle

    This will get you quite close.

    Please Login or Register  to view this content.
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    04-01-2014
    Location
    Kansas City, US
    MS-Off Ver
    Excel 2007
    Posts
    10

    Re: vba import picture change shape to rectangle

    Doesn't work says compile error method or data member not found

+ 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] Passing a range to a sub from a shape (rectangle) on the worksheet
    By wazimu13 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-27-2013, 01:01 PM
  2. Add command button to shape and change shape color on mouseover
    By maacmaac in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-26-2012, 05:12 PM
  3. Adding a colored shape (rectangle) to a footer
    By tommyfernandez in forum Excel General
    Replies: 2
    Last Post: 12-19-2012, 02:34 PM
  4. Import web data into excel does not import picture, how to substitute picture for a value
    By anrichards22 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-19-2012, 03:29 AM
  5. How Do I change the Shape of the Comment Box to Folded Corner Shape?
    By e4excel in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 09-01-2011, 08:17 AM

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