Educational Revolution

  Picture Lookup [ photo lookup] In Excel - Learn how to quickly lookup pictures based on the value of a cell [drop down list ]. Some people call this V LOOKUP on pictures images. You can use this picture vlookup for company logos, employee pictures, flags - basically anywhere where you need to show different images based on the value of a cell. This Excel tutorial explains you how to lookup a picture in excel Hindi with example. Create a picture lookup in Excel. Display a picture dependent upon the contents of another cell. Video For Complete explanation

Public Sub FitPic() On Error GoTo NOT_SHAPE Dim PicWtoHRatio As Single Dim CellWtoHRatio As Single With Selection PicWtoHRatio = .Width / .Height End With With Selection.TopLeftCell CellWtoHRatio = .Width / .RowHeight End With Select Case PicWtoHRatio / CellWtoHRatio Case Is > 1 With Selection .Width = .TopLeftCell.Width .Height = .Width / PicWtoHRatio End With Case Else With Selection .Height = .TopLeftCell.RowHeight .Width = .Height * PicWtoHRatio End With End Select With Selection .Top = .TopLeftCell.Top .Left = .TopLeftCell.Left End With Exit Sub NOT_SHAPE: MsgBox "Select a picture before running this macro." End Sub