Author: Oscar Cronquist Article last updated on July 11, 2018

Rahul asks:

i want to know that when we create a vlookup sheet, and in the name column we enter a name and excel shows all details and a photo.



Formula in cell C4:


Formula in cell C6:


I have hidden the contents in cell C6. Select cell C6. Press Ctrl + 1. Click Custom and type ;;;

VBA code

  1. Right click on sheet name
  2. Click "View Code"
  3. Paste code below to sheet module
  4. Exit VB editor
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$C$2" Then
    With Selection
        .Height = 120.24
        .Width = 180
        .Left = 96.75
        .Top = 90
    End With
End If
End Sub

Data sheet

change picture - data sheet

Download *.zip file