+ Reply to Thread
Results 1 to 5 of 5

Trouble resizing an image on a User Form

  1. #1
    Forum Contributor
    Join Date
    04-11-2012
    Location
    Chicago, IL
    MS-Off Ver
    Excel 2010
    Posts
    245

    Trouble resizing an image on a User Form

    Hi -

    Looking to resize an image ( a logo) on a User Form I've created. My code pulls in the image but does not "zoom" the image to the size of the container (the image box named Image1).
    FYI, my image dimensions are 112 x 112 (pixels). See sample wrbk attached

    I realize I could simply create and resize a second logo image but I prefer to store only one image and modify its size as needed using code.

    Please Login or Register  to view this content.
    Attached Files Attached Files

  2. #2
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,905

    Re: Trouble resizing an image on a User Form

    Hi, I have no idea what the size of your bmp file is but it works here.
    you can also try
    Please Login or Register  to view this content.
    But this does not keep the ratios right
    ---
    Hans
    "IT" Always crosses your path!
    May the (vba) code be with you... if it isn't; start debugging!
    If you like my answer, Click the * below to say thank-you

  3. #3
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,905

    Re: Trouble resizing an image on a User Form

    Tried more, but works fine here as you had you code initially

  4. #4
    Forum Contributor
    Join Date
    04-11-2012
    Location
    Chicago, IL
    MS-Off Ver
    Excel 2010
    Posts
    245

    Re: Trouble resizing an image on a User Form

    Ahhh. So the problem has do with the settings of the Image box itself. I had "Autosize' set to True. When I changed this setting to False, the fmpicturesizemodeZoom worked just fine.

  5. #5
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,905

    Re: Trouble resizing an image on a User Form

    Great to her, don't forget to mark the post as SOLVED
    Happy coding

+ 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] Help resizing image - produces different image size on different computers.
    By Andrew Entee in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-18-2017, 01:47 PM
  2. [SOLVED] Activating an Image in a User Form
    By bralew in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 09-15-2016, 10:56 AM
  3. [SOLVED] VBA-How can I add a GIF image to a user form?
    By StuCram in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-28-2014, 11:05 PM
  4. Can this be done? (Trying to change an image in a user form)
    By Fenway55 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-16-2013, 09:37 PM
  5. Image instead of message in User form
    By Tunk Ayauit in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 11-28-2011, 01:55 PM
  6. Placing and resizing an image + delete existing image
    By dsheets05 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-01-2011, 09:05 PM
  7. [SOLVED] Resizing user form in excell
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-27-2006, 12:25 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