How to make cell notes position where i have moved them on hover.

Hi there,

Not sure 'Comments' can be set to open by hovering over in a specific location.

For your consideration, I have added a couple of alternatives in the attached workbook.

On the sheet 'Workings' click/select any of the cells with 'comment...' and the corresponding picture will show in the frame set.
How it works: A change event will set the value of cell 'D2' on Sheet 3. There is a lookup function in a defined range which will show the corresponding picture. This is then projected/shown using the 'Camera' tool onto the 'Workings' sheet in the specific location.
This is the easiest method to maintain. No 'UserForm' setup required.
The Defined Range will need to be expanded when additional images are loaded.

On the sheet 'UserForm' the pictures are set into 'UserForms'.
How it works: Again a change event will trigger which form is to be shown. The setting of the specific location where the form is to be shown is a bit trickier. This is set in each individual UserForm. A bit more involved as a UserForm needs to be setup for each picture. Also, the exact position can vary by user.
There is also an option (Sheet1) to store all the images in one 'UserForm' and use the sheet change event to trigger which picture to show/hide.


Hopefully this gives you some ideas...

Let us know how you go with this or if you need another solution.

Glad it gave you some ideas.

I get the restriction not being able to use VBA. VBA is great to determine the address of the current cell, or as in the previous sample file, run based on a cell selection change.

Without VBA, I don't know a way of determining where (which cell/row) the user is (hoover/select/click a specific cell) to use that cells' value to lookup the relevant picture.

A dropdown list works, but I guess you need to manually select a value for the selection...?