I wrote a macro that allows the user to load in an image from a a file and then displays that image in a userform. I need the entire image to be displayed on the monitor regardless of the screen resolution. However, if the original image is larger than the screen resolution, only part of the image is displayed. Of course, one could scroll down to see the rest of the image, but this is unacceptable. I realize that I can determine the screen resolution of any monitor on which the macro is used, and I know that I could resize the userform so that the whole userform is visible regardless of the resolution. The question is, how can I resize the original image so that the entire picture will display in the userform at any resolution? I don't want the users to have to resize the image in a different program before opening it in Excel.