Fix Excel 2016 UserForm Images That Do Not Display or Resize
Question details
The user needs images to display and fit correctly in an Excel VBA UserForm after an Office upgrade.

- Product
- Microsoft Excel 2016 VBA UserForm
- Device & OS
- not provided
- Scenario
- An older UserForm is opened in Excel 2016, and the user wants existing and new pictures to appear correctly in an Image control.
- Observed behavior
- Images may not display or resize correctly, and newly assigned JPG, BMP, or GIF files may not appear.
Open the workbook containing the UserForm and identify the Image control that should display the picture. Have a local copy of a supported image file available for testing.
Set the UserForm Image control to Zoom and verify its picture
Use this method when a UserForm picture is clipped, does not fit the control, or is missing after an Excel upgrade.
Zoom scales a picture to fit the Image control while preserving its aspect ratio. It can correct sizing or clipping, but it will not by itself load a missing picture.
In Excel, press Alt+F11 to open the VBA editor. In Project Explorer, expand the workbook and double-click the affected UserForm.
Click the Image control on the UserForm, then press F4 to open its Properties window. Check the control name at the top to make sure you selected the intended control.
In the Properties window, find PictureSizeMode and change it from Clip to Zoom.
If the picture is still missing, select the Picture property and use its browse button to choose a valid JPG, BMP, or GIF file. Confirm that the picture is assigned to the intended Image control.
Run the UserForm from the VBA editor using Run > Run Sub/UserForm, and check whether the picture appears and fits the control.

Work with spreadsheet images in WPS Office
WPS Office is a free, lightweight alternative with a familiar interface for working with spreadsheets and images. Open compatible Excel files to make everyday spreadsheet edits, but use Microsoft Excel to troubleshoot its VBA UserForm controls.

Frequently Asked Questions
What does PictureSizeMode Zoom do in a UserForm?
Zoom scales the picture to fit the Image control while preserving its aspect ratio. Select the control in the VBA editor and change PictureSizeMode in the Properties window.
Why is my UserForm picture still blank after I select Zoom?
Zoom changes sizing but does not load a picture. Check the selected control's Picture property, try another supported image file, and review any VBA code that assigns or clears the picture.
How do I open the Image control's properties?
Press Alt+F11 in Excel, open the UserForm from Project Explorer, select the Image control, and press F4 to show its Properties window.
Can WPS Office fix an Excel VBA UserForm control?
WPS Office can work with spreadsheet images and common Excel file formats, but it does not fix Microsoft Excel's UserForm control settings. Use Excel's VBA editor to troubleshoot the control.




