Add Comment Automatically when value is "-"

[umer_what]

Dear Friends,

I am new in this forum. I just want to put automatic comment when cell value is "-". The sheet is attached.

Thanks..

[NickyC]

I would use a macro, something like this (change the word "comment" in the bracket to the text your want to add):

Please Login or Register  to view this content.

[umer_what]

Thanks for the swift reply... what about when I update the cell value... the comment was still there once I update... and guide me each time I have to run the macro?

Regards.

[NickyC]

hi
you could set up the macro to delete comments as well as add them if you like. One way to do this would be to set up a macro that runs whenever you change the worksheet, but these can slow your machine up if you have lots of data and calculations.

To do this, right click on the tab with the sheet name at the bottom of the sheet, select "view code" and paste this macro into the sheet's VBA area:

Please Login or Register  to view this content.

note the treatment of the comment text here is little different - I have created a variable as the same text is deleted in the first half of the macro, and added in the second half.