ANmarS - Portfolio - XLThumbs

Excel/VBA expert since Sep 1997 (21 years 3 months)

We are moving ...

We are moving to another location, better, faster and more resources .... check it out ANmar.Systems

XLThumbs    Added: 6/27/2015 | Created: 6/27/2015   

Show pictures inside Excel sheet as Thumbs (Listview like) with ability to enlarge any picture with single click and auto-arrange in user-defined number of columns


  • Automatically arrange images in sheet based on pre-set settings (in Settings sheet)
  • Enlarge picture when click, restore it when clicked again or clicked any cell
  • Modify number of columns to show these pictures
  • Modify X and Y for first (top left) image
  • Modify horizontal and vertical spavec between these images
  • VBA code available to anyone
  • User can modify almost everything in Settings sheet

To apply to your sheet:

  1. 1- Insert all pictures
  2. 2- Each picture should have its own unique name
  3. 3- Modify settings in Sheet to have pictures count, and name of these pictures in order, order in Settings sheet will be the order that they will be arranged
  4. 4- Add code in VBE for each individual pic, "Sub Enlarge_Pic8()" from mMain module

Download (452.5 KB)

852 downloads | Last updated: 6/27/2015

Screen shots (10)