
Active Member

July 24, 2013

Hi, Is there a way of dynamically displaying the reults of a formula in a comments/text box? In the attached spreadsheet, I have a table of people and their test assessment levels in the two adjacent columns. The range H4 to J6 is a count of the numbers of people at an intersection between the result they achieved in test 1 and test 2. E.g. cell H4 is the number of people who were "Above" in both tests and J5 are the names of those who "Attained" in the first test and were "Below" in the second. In the comments boxes are the names of those individuals which I would like to change dynamically as and when the test results change . I want to be able to have the same functionality in all the yellow highlighted cells. Thanks for your help and please let me know if you would like any further information.
Cheers,
Mark

VIP

Trusted Members

June 25, 2016

Hi Mark
I don't think you can display the result of a formula in a Comment. You will need VBA for that.
What you request is complex and difficult to do as you need to (1) get the required names and then (2) put the result into the comments dynamically.
The best I can come up with is the attached. The range is hard-coded and it uses a worksheet change event.
Any changes in the Result range will trigger the update. Not sure if it will work for other scenarios.
Good luck.
Sunny

Answers Post

VIP

Trusted Members

June 25, 2016

1 Guest(s)
