VBA & Macro Problems

Fix Excel 2016 UserForm Images That Do Not Display or Resize

Huda QurayshiHuda Qurayshi Nov 14, 2026 870 views

Question details

The user needs images to display and fit correctly in an Excel VBA UserForm after an Office upgrade.

Fix Excel 2016 UserForm Images That Do Not Display or Resize
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.
Before you start

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.

Solution 1Recommended

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.

1
Open the UserForm

In Excel, press Alt+F11 to open the VBA editor. In Project Explorer, expand the workbook and double-click the affected UserForm.

2
Select the Image control

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.

3
Change the sizing mode

In the Properties window, find PictureSizeMode and change it from Clip to Zoom.

4
Check the assigned picture

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.

5
Test the UserForm

Run the UserForm from the VBA editor using Run > Run Sub/UserForm, and check whether the picture appears and fits the control.

Set the UserForm Image control to Zoom and verify its picture
If the image is still missing: Try another supported image file and check any VBA code that assigns or clears the control's Picture property when the form opens.
Free Microsoft Office alternative

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.

Insert and resize pictures directly on a spreadsheetOpen and edit common Microsoft Excel formats, including XLSX and XLSUse a familiar spreadsheet interface for an easier transitionWork with a free, lightweight office suite
microsoft office alternative - wps office

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.