Hi.
Is it possible to have a code that will remove the 'comment' from an Excel cell once that cell has been populated.
I have a number of cells that have a comment explaining to an operative what is required in the cell.
Once the operative has populated the cell with the required information, I would like the cell to have the comment deleted.
Thank you in advance for any help you can offer me.
Hi Coach,
No problem. The code behind the worksheet is:
Find the attached with a few comments on it. As soon as you put something into any cell the comment for that cell is deleted.
Private Sub Worksheet_Change(ByVal Target As Range) Target.ClearComments End Sub
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks