VBA code to refresh comment

[mdot218]

Hello All

I am currently putting a workbook together for staff rosters.
Sheet 1 will be the data entry, and I will insert comments when a cell reads either L or A.
On sheet 2, I used getComment to display the comments.

The trouble I am having is if I edit the comment on sheet 1, sheet 2 will not show the new edited comment.

I have tried various codes to refresh the workbook, but nothing seems to work.

Any help will be greatly appreciated.


regards

Darren