Results 1 to 5 of 5

Loading an image into Userform.Image and loss of image quality

Threaded View

dareksg Loading an image into... 02-21-2023, 03:30 PM
jolivanes Re: Loading an image into... 02-22-2023, 04:32 PM
Marc L Re: Loading an image into... 02-24-2023, 08:07 AM
Artik Re: Loading an image into... 02-24-2023, 10:19 AM
dareksg Re: Loading an image into... 02-26-2023, 05:20 PM
  1. #4
    Forum Expert
    Join Date
    08-17-2007
    Location
    Poland
    Posts
    2,525

    Re: Loading an image into Userform.Image and loss of image quality

    dareksg, I've arranged for you to rotate the image on each computer (at least I hope so ) using a different method than copying the chart. But keep in mind that the rotation occurs only in the UserForm, into the sheet the image is inserted in its original form.

    Consider whether the clicked image needs to be opened in an external program. Since you're storing images in the workbook, maybe zooming the image can also happen in the workbook. When you open an image in an external program, especially small images can be distorted because that program can zoom in to fill the entire screen (or at least a large part of it). Then the original pixels are enlarged, which ends up blurring the image. And you are unlikely to be able to control the scale of this zooming.
    If you choose to enlarge the image in the sheet, then you can control the magnification size yourself. For example, you click on the image and it zooms in 2 or 3 times (depending on what magnification scale you choose). Another click on that image (enlarged) should return it to a small size.

    Attention. The code is adapted to the 32-bit version of MS Office. For the 64-bit version, the winAPI function declarations must be adjusted accordingly.

    Artik
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Userform Image Control - Show specific region of Image
    By PrizeGotti in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 11-09-2021, 12:04 PM
  2. Image Pop Up on Mouse Hover over image on userform
    By mc84excel in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-31-2019, 04:43 PM
  3. Inserting image into userform label, text behind image?!?!
    By spyrule in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 0
    Last Post: 08-31-2016, 03:23 PM
  4. Replies: 1
    Last Post: 07-14-2016, 04:59 AM
  5. [SOLVED] Using a Userform to Browse image file then paste selected image to sheet?
    By matrixpom in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-05-2015, 05:42 PM
  6. [SOLVED] How to apply Image borders to an image that my excel vba userform pastes in a word doc?
    By CaptainCool in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-11-2014, 05:40 PM
  7. [SOLVED] VBA to transfer image FROM userform image control TO a worksheet cell
    By Zoediak in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-01-2014, 02:51 PM

Tags for this Thread

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