pctechguide.com

  • Home
  • Guides
  • Tutorials
  • Articles
  • Reviews
  • Glossary
  • Contact

Quick and Simple Guide to Creating Image Catalogs in Excel

People use Excel to store various types of data. In many cases, this data needs an associated image. You need to know how to create a catalog of images in Excel that can be linked to our database.

HOW TO CREATE IMAGE CATALOGUES IN EXCEL

There are several methods to create an image catalog in Excel. Some Excel users prefer to implement the catalog by embedding the image associated with each record into the Excel sheet. However, if you have a database with many records you will end up with an Excel book that is too large because of the size of the images which will make it difficult to manage.

I always recommend using a VBA method because it allows us to leave the image files in a local folder on the computer and only load the images as they are used within our Excel database.

THE KEY TO CREATE THE IMAGE CATALOG

The key to having a catalog of images in Excel is to have a sheet that relates the “primary key” of our records with the corresponding image. If you are not familiar with the term “primary key” I recommend you read our previous articles on Database Design.

In the following example, you will see that I have a list of 5 Blu-ray movies and each of them has a unique product key.

How to create a catalogue of images in Excel

The images of each product will be stored in a directory called “images” and will have the same name as the product code to which they belong. Having the images with the same name as the product code will make it easier to manipulate them.

Repository of images for catalogue in Excel

INSERT AN IMAGE CONTROL

In order to be able to observe the product face image, I will insert an Image Control which is a type of ActiveX control. To do this I must go to the Programmer tab and in the Insert button select the appropriate control.

CREATE THE MACRO TO SHOW THE IMAGE

For this example, I will show the image when selecting a cell in the Code column. I will use the event Worksheet_SelectionChange. Right click on the name of the sheet and select the option View code and in the Visual Basic Editor select the event SelectionChange. Next, you will see the VBA code for that event:

Macro for Excel image catalog

The important part of this code is that when we select any cell within the A2:A6 range the Picture property of the Image1 object will be modified. The LoadPicture instruction is responsible for loading the image stored on our local hard drive:

LoadPicture(ActiveWorkbook.Path & “Images\” & Target & “.jpg”)

The ActiveWorkbook.Path instruction returns the current directory of the Excel file and concatenates it with the “images” directory where our files are located. Subsequently, the Target variable is concatenated, which contains the value of the selected cell and the extension of the image files is added, which for our example are JPG files.

TESTING THE CATALOG OF IMAGES IN EXCEL

Finally, I will prove that the newly created macro works correctly for our image catalog in Excel:

Example of an Excel image catalog

There are variants on this method and surely in another article, we will have the opportunity to explore different methods to show the images associated with a record of our database in Excel.  To continue with the tests you can download the workbook used along with the example images.

Filed Under: Communications

Latest Articles

Hard Disk AV Capability

Audio-visual applications require different performance characteristics than are required of a hard disk drive used for regular, everyday computer use. Typical computer usage involves many requests for relatively small amounts of data. By … [Read More...]

CDR-RW Double Density Media

The idea of a double density writable and rewritable CD media is not new. In the early 1990s a number of companies experimented with extending the White Book and Red Book standards to store large amounts of video. However, these technologies were … [Read More...]

Keep Your Browsers Private With These Extensions

Privacy is a big concern for people online these days. Everyday we seem to be hearing about some new invasion of privacy centered around the Internet. But, there are a few tools at your disposal to keep your data safe and your browsing secure. These come through add ons in your browser called … [Read More...]

Why Internet Bundles Are the Next Battleground for Gamers

A weak internet connection can turn seamless gaming sessions into frustrating experiences filled with lag, buffering or sudden disconnects. For … [Read More...]

Importance of Inbound Marketing in the Digital Age

A couple of months ago, Zacks reported that Hubspot was starting to make some major changes to its inbound marketing strategy. They talk a lot about … [Read More...]

Damage Control Strategies for Resolving Online PR Crises

Last July, Astrologer faced a major crisis after its CEO went viral at a ColdPlay concert when having an affair. This was just one of the many times a … [Read More...]

AI is Not Killing Computer Jobs Like Doomers Projected

There is no denying the reality that AI technology has played a massive role in disrupting our lives. A growing number of people claim that AI … [Read More...]

Everything You Need to Know About Sourcing Circuit Boards From U.S. Suppliers

In This Article This article includes: Why Source PCBs From the United States?How to Get a Quote From a U.S.-Based PCB ManufacturerThe Top U.S. … [Read More...]

Top Taplio Alternatives in 2025 : Why MagicPost Leads for LinkedIn Posting ?

LinkedIn has become a strong platform for professionals, creators, and businesses to establish authority, grow networks, and elicit engagement. Simple … [Read More...]

Guides

  • Computer Communications
  • Mobile Computing
  • PC Components
  • PC Data Storage
  • PC Input-Output
  • PC Multimedia
  • Processors (CPUs)

Recent Posts

1999 Site Updates

Date Details of updates 22Dec '99 New millennium changes: The site is honoured to become an affiliate of the Maximum PC Network, operated by … [Read More...]

Intel 820 Chipset

Test - Originally scheduled to be available concurrently with the Pentium III processor in the spring of 1999, Intel's much delayed 820 chipset … [Read More...]

Fatal Exception OE Errors

Anybody who owns a PC has probably seen enough error screens to last a lifetime. Out of all of these possible error messages, one of the most … [Read More...]

[footer_backtotop]

Copyright © 2026 About | Privacy | Contact Information | Wrtie For Us | Disclaimer | Copyright License | Authors