code to automatically convert cell text to comments

Try this.

Private Sub Worksheet_Change(ByVal Target As Range)
'Works on A1:A10, change your cells to your desired range.
If Target.Cells.Count > 1 Then Exit Sub
    If Not Intersect(Target, Range("A1:A10")) Is Nothing Then
    Application.EnableEvents = False
        Target.ClearComments
        Target.AddComment Target.Text
        Target.ClearContents
    Application.EnableEvents = True
    End If

End Sub

Right click on the tab you want this code to run on and choose view code, then paste in the code.
The ranges are set for A1:A10, change this to suit your needs.

prakash24,
Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.

---

Don't quote whole posts -- it's just clutter. If you are responding to a post out of sequence, limit quoted content to a few relevant lines that makes clear to whom and what you are responding

For normal conversational replies, try using the QUICK REPLY box below.

---

You have 36 posts and you post a picture of the VBE and say fix it