ANmarS - Portfolio - XLThumbs

Excel/VBA expert since Sep 1997 (20 years 11 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

Features:

  • 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)

832 downloads | Last updated: 6/27/2015


Screen shots (10)