Options for displaying changing data against a cell when clicking, or hovering over.

Hi,

I'm looking for options for displaying data when hovering over a cell. I have a list of items that I need to display in a simplistic visual way. The items are categorised, for example, as 'data migration' 'data prep' etc... they maybe applicable to all, or some of the categories. The data is listed in multiple rows. They will get updated on a monthly basis. I would like to be able to represent the data in a 'schedule' visual format with the data clustered at the milestones along the bar. As it will be updated on a monthly basis I don't want to have to copy and paste into a 'comments' box, or into the 'Input message' I don't think it would have enough space.

Any recommendations gratefully received. I am a limited experienced user of excel, so the more simplistic the better!


Thank you kindly,

Georgina

See the attached Excel file. Ensure macros are enabled.

Clicking on cell A3 up to E3 will open individual userforms. I used 5 examples in this case. Wikipedia articles on MS Word were used to fill the userforms for a visual
example. The userforms display data via a label, however if you want more control with tables, charts, graphics etc., you can create the graphic in your regular software
of choice, take a screenshot and crop it as needed and insert it in the userform (clicking DATA 5 will show an example of this using a chart taken from Wikipedia as
well). Accepted picture formats are jpeg and bitmap.

You can resize the userforms as needed.
You can edit the VBA (Visual Basic for Applications) code as required to set the userform to open on click in whatever cell you wish.
You can create more or less userforms if you wish.

You can access the VBA code in the VBA Editor => Project - VBAProject => VBAProject(Book1.xlsm) => Microsoft Excel Objects => Sheet1 (Sheet1). These are all in the upper
left pane of the VBA Editor.

The VBA project is protected with a password for example if you want to prevent users from being able to edit/delete the userforms etc. Clicking the Update Data Sources
button will open the VBA Editor, and the generic password is set to, in this example, "123" (without quotation marks).

Another 'simpler' solution would be to create your files (charts/schedule etc. in your software of choice) and store them in a folder and use hyperlinks to open them via your Excel sheet.