June 21

Interactive Periodic Table of Elements in Excel

I’ve been on a real rollover kick lately. I’m really trying to figure out if it can be useful. Earlier today I started making a Periodic Table of Elements using Excel. I employed the rollover technique to allow the user to gain information about an element simply by rolling over a cell. Well, for some reason, I couldn’t stop there. So what was meant to be a small project ballooned into something larger. Unfortunately, my sticking to good coding practice didn’t keep up with craving to do more. So what I present to you below isn’t really a polished product. If you poke through the named ranges and the rollover indexes, you’ll probably see that I add and subtract one to them somewhat randomly (a cheap trick – this is  due to my trying to reconcile the table copied from Wikipedia with my indices).

As you can see below (sorry for the graininess of the recorder–be sure to download it to get the full effect), you can not only gain information about an element but you can also toggle on and off different element groupings.

periodic2

If you want to “crack” the file, the first thing you’ll need to do is reset the ScrollArea (Click on a cell. Go to the Developer tab, click Properties. Delete the reference in the ScrollArea box.). Then just unhide everything.

Good luck.
Periodic Table.xlsm

Update –
Reader Dario found an error in the spreadsheet (see the comments) – this is the result of some carelessness and cheap tricks on my part. An updated version will be released tonight. In the meantime however, you can still poke around the file :).

Another Update –
I’ve since fixed the bug described in the reader comments. If you find anything else, let me know!


Tags


You may also like

51: Oz du Soleil & the Global Excel Summit 2021

51: Oz du Soleil & the Global Excel Summit 2021

Global Excel Summit 2021

Global Excel Summit 2021
  • Is there a bug or is it just a functionality or lack thereof that if you hover over the cells from left to right that it skips one. From right to left it doesn't skip any.

  • Thanks for pointing that out to me. That is indeed an error – the result of my using cheap tricks instead of good programming practices. I've since fixed the problem – however, I am not able to upload the new file while at work. Tonight the new file will be uploaded in its place.

  • Really, really nice. Is there an explanation anywhere on what you did. How would I go about modifying the overall structure, if I wanted to highlight different portions of a worksheet, nothing in particular in mind at this point.ThanksAl

  • Sorry, I never really completed the tutorial for this. However, you might find these tutorials helpful:http://optionexplicitvba.blogspot.com/2012/06/how-to-highlighting-cells-using.htmlhttp://optionexplicitvba.blogspot.com/2012/09/handling-rollover-clicks-without-using.htmlhttp://www.clearlyandsimply.com/clearly_and_simply/2012/11/roll-over-tooltips-and-web-actions-on-a-microsoft-excel-dashboard.htmlAs well, you can go snooping through the file – I'm available by email to answer specific questions 🙂

  • A very nice functionality…. Would it be easy to have a version where the extra info is displayed when you click on an element, instead of hovering over it?

  • Hi Jordan
    I really like it. Would be possible to have the extra information display when you click on a cell with the element, not on hover?

  • +1 for repost the file. I want to do something with exact same idea, but I don`t have Excel knowledge for this (yet). Playing with your file would be awesome.

  • {"email":"Email address invalid","url":"Website address invalid","required":"Required field missing"}

    Free Power User Quick Guide

    Discover The BEST Ways To Use Lookups And Conditional Calculations Quickly And Easily With This Reference Guide -- You Won’t Want This To Leave Your Side

    With so many ways to use Excel, it can be difficult to memorize all of the key functions, calculations, and techniques you can employ to meet your goal: simply get the job done.

    >