Data Validation Images

From Dataspectrum’s Excel Tips and Tutorial’s

Do you think, data validation feature allows you text selection only? Let me convince you are mistaken. You can donwnload the Excel file with live example extending data validation ability to work with embedded images list.

fish data validation

The images aren’t in the dropdown (that’s what I thought), but the validation selection changes an adjacent image. The workbook has very detailed instructions for how to do it. Even if you have no use for it, there are cool fish pictures to look at.

The author, Jiri Cihar, writes:

Entirely free of VBA.

You’ll get a macro warning dialog because there’s an empty module in the workbook.

Posted in Uncategorized

5 thoughts on “Data Validation Images

  1. After running 1 of the 3 (not sure which one) programs that you allowed users to download, my Excel application now will not work properly.

    When I open a workbook, Excel opens it, but then hides it, and I cannot perform any type of action with the mouse. I can “kludge” my way into Excel, and proceed normally, but this was quite an unexpected surprise.

    Any suggestions?

  2. Fred: I’m happy to help, but you’ll have to be more specific. Which three programs that I “allowed” you to download did you, in fact, download.

  3. Badly explained. I cannot get it to work. Can someone make it more step by step and update it to excel 2007?


Posting code? Use <pre> tags for VBA and <code> tags for inline.

Leave a Reply

Your email address will not be published.