How can i add the comment in the cell

[karthisucc9]

Hi All

I am new to excel vba. In my project i have a text box where the user has to enter

the comments.

Where the cursor is there whatever the user enters the data should comment

in the particular cell

How can i do it.

and i have to remove the comment. How can i do it.

[Cutter]

Have you tried recording a macro while adding/removing a comment and then looking at the code?

[karthisucc9]

Actually I am new to excel. I did not tried any one. i have to add comments in a particular cell. What i have to do.

[rvasquez]

Hello karthisucc9,

Attached is a spreadsheet I believe accomplishes what you are trying to do. I added a label above the comment box entitled "Comments. The button below the text box is known as an ActiveX command button. If you would like to see the code you can go under the developer tab and then click Visual Basic. I have left some comments within the code to help you adjust it to your needs.

Please let me know if you have any questions.

If this post help you please add to my reputation points by clicking the star. Thanks!