Dynamic Comment Box - Multiple cells

[Tai1001]

Hi Guys,

I have read through the forum for help on dynamic comment box, I am having difficulty with coming up with a macro because there are lots of comment boxes which i need to create/update.
I have attached the file to this thread.

So Student Data sheet Column A has the names of the students.
Each student has number of tests to do (these are different for each student).
Column B of "Test Data" sheet has the dynamic formula which is for each student.
As you hover over the student name, the comment box show display the value in "Test data" sheet. (I haven't created all the comment boxes yet).

Can anyone help please?

Thank you

[LeoTaxi]

Please Login or Register  to view this content.

Kind regards
Leo

[LeoTaxi]

Or

Please Login or Register  to view this content.

Kind regards
Leo

[jindon]

Try

Please Login or Register  to view this content.

[Tai1001]

Hi Guys,

Thank you for your help, this works great.
I had a quick question (just in case in the future it happens). if I have a new table in Student Data sheet from Column H to L with similar data, how will this affect the code?

Thanks
Tai

[jindon]

Set the column "myCol"

Please Login or Register  to view this content.