+ Reply to Thread
Results 1 to 3 of 3

resize loaded picture to activex image object size

  1. #1
    Forum Contributor
    Join Date
    07-22-2013
    Location
    Sibiu
    MS-Off Ver
    Excel 2007
    Posts
    114

    resize loaded picture to activex image object size

    Hi guys, I am using this code to load a picture from a folder using a combobox to search for the filename.
    I would like the loaded picture to be the same size as the image object that I inserted in my sheet.
    Any ideeas on how I could to this?

    Please Login or Register  to view this content.

  2. #2
    Forum Expert Kenneth Hobson's Avatar
    Join Date
    02-05-2007
    Location
    Tecumseh, OK
    MS-Off Ver
    Office 365, Win10Home
    Posts
    2,573

    Re: resize loaded picture to activex image object size

    An API method would be best. When you set the dimensions the same, scaling is not the same. e.g.
    Please Login or Register  to view this content.
    The API method:
    Please Login or Register  to view this content.
    Put this into a Module:
    Please Login or Register  to view this content.
    Last edited by Kenneth Hobson; 07-27-2016 at 09:54 AM.

  3. #3
    Forum Contributor
    Join Date
    07-22-2013
    Location
    Sibiu
    MS-Off Ver
    Excel 2007
    Posts
    114

    Re: resize loaded picture to activex image object size

    thank you for the help. solved.

+ 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. Replies: 5
    Last Post: 03-29-2021, 03:01 AM
  2. set webbrowser object to match size of the image loaded
    By JasperD in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-08-2015, 06:11 AM
  3. Copy picture from ActiveX Image Command to a cell
    By jdvdh in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-25-2014, 03:38 PM
  4. Image picture resize and save as on differen location
    By cemregunay in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-21-2014, 06:30 AM
  5. [SOLVED] ActiveX image and size of file
    By Kiwoop in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-01-2013, 10:25 AM
  6. ActiveX Image Picture File Size
    By mgalterio in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-07-2012, 04:02 PM
  7. Paste picture in & have it resize to merged cells size
    By simonwilliams in forum Excel General
    Replies: 0
    Last Post: 10-02-2011, 03:12 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