Results 1 to 12 of 12

How do I Resize image with userform

Threaded View

RincewindWIZZ How do I Resize image with... 02-25-2015, 06:50 PM
Andy Pope Re: How do I Resize image... 02-26-2015, 04:40 AM
RincewindWIZZ Re: How do I Resize image... 02-26-2015, 04:59 AM
Andy Pope Re: How do I Resize image... 02-26-2015, 05:06 AM
RincewindWIZZ Re: How do I Resize image... 02-26-2015, 05:59 AM
RincewindWIZZ Re: How do I Resize image... 02-26-2015, 07:07 AM
RincewindWIZZ Re: How do I Resize image... 02-26-2015, 06:18 AM
Andy Pope Re: How do I Resize image... 02-26-2015, 08:13 AM
RincewindWIZZ Re: How do I Resize image... 02-26-2015, 11:03 AM
Andy Pope Re: How do I Resize image... 02-26-2015, 11:07 AM
RincewindWIZZ Re: How do I Resize image... 02-26-2015, 12:42 PM
RincewindWIZZ Re: How do I Resize image... 02-26-2015, 06:12 PM
  1. #1
    Registered User
    Join Date
    03-03-2005
    Posts
    41

    How do I Resize image with userform

    I have a userform that I am using as a splash screen while the spreadsheet loads and does some initial processing


    So the userform is called Splashscreen
    The userform has an image which exactly fills the userform. The userform properties for the image are
    .picturealignment is set to 0 (frame Top Left)
    .fmPictureSizeMode is set to 1 (fmPictureSizeModestretch)
    .zoom is set to 100
    SplashScreen.Show           
    SplashScreen.Height = Application.UsableHeight
    SplashScreen.Width = Application.UsableWidth
    The userform resizes correctly but the image does not resize at all.
    It makes no difference if I set .fmPictureSizeMode is set to 3(fmPictureSizeModeZoom)

    I can set the zoom and that does make the image change size but both dimensions change the same amount
    However the client monitor can be square, wide or almost any other shape si some of the splashscreen image will be lost.
    Is there any way I can stretch the image to follow the userform? (recognising that the image will be distorted if the aspect ratio is changed)

    TFAI
    Last edited by RincewindWIZZ; 02-25-2015 at 07:34 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. how do I scale/resize an image with VBA
    By bsapaka in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-01-2014, 07:14 PM
  2. resize image with vba
    By 13lack13lade in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-19-2013, 08:59 PM
  3. [SOLVED] How do I resize an inserted image in a cell?
    By tigerbenn in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-17-2012, 10:55 AM
  4. Image file resize
    By D_Rennie in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-10-2009, 05:01 AM
  5. resize userform image to fit on any monitor
    By timspier in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-05-2006, 01:50 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