How to enlarge image when click on it in Excel?

Supposing you have inserted a list of pictures into a column and matched the picture sizes with the cell sizes as below screenshot shown. As the inserted picture looks small, you may need to enlarge it for some purposes. This article will show you method of enlarging a picture when clicking on it in Excel, and restoring to the original size with a second click.

Enlarge image when click on it with VBA code

Enlarge image when click on it with VBA code

The following VBA code can help you to enlarge an image when click on it in Excel. Please do as follows.

1. Right click the picture which you need to enlarge by just clicking on it, then click Assign Macro from the context menu. See screenshot:

2. In the Assign Macro dialog box, please click the New button.

3. In the popping up Microsoft Visual Basic for Applications window, please copy and paste the below VBA code between the Sub and End Sub codes. See screenshot:

VBA code: Enlarge image by click on it in Excel

Dim shp As Shape
    Dim big As Single, small As Single
    Dim shpDouH As Double, shpDouOriH As Double
    big = 3   
    small = 1 
    On Error Resume Next
    Set shp = ActiveSheet.Shapes(Application.Caller)
    With shp
        shpDouH = .Height
        .ScaleHeight 1, msoTrue, msoScaleFromTopLeft
        shpDouOriH = .Height
    
        If Round(shpDouH / shpDouOriH, 2) = big Then
            .ScaleHeight small, msoTrue, msoScaleFromTopLeft
            .ScaleWidth small, msoTrue, msoScaleFromTopLeft
            .ZOrder msoSendToBack
        Else
            .ScaleHeight big, msoTrue, msoScaleFromTopLeft
            .ScaleWidth big, msoTrue, msoScaleFromTopLeft
            .ZOrder msoBringToFront
        End If
    End With

Note: In the code, you can assign the large sizes of the picture in the code big = 3.

4. Then press the Alt + Q keys simultaneously to close the Microsoft Visual Basic for Applications window.

From now on, when click on the picture, it will be enlarged to the size you specified, and clicking it again will restore it to its original size, as shown in the screenshots below.

Related articles:

• How to lock picture/image to or inside cell in Excel?
• How to insert image or picture dynamically in cell based on cell value in Excel?