Macro for comments

Hello guys. I need little help with a macro I am trying to create. I need it to add a comment on ActiveCell, then to Paste in the comment my clipboard then to close the Comment box. When I record a macro, I am able to do all of this except the "Paste part".

For example this is my macro

Please Login or Register  to view this content.

I just need this in red (ASDQWE) to be from my clipboard. When I copy something new just to paste it to the new cell I want to add a comment. Thanks

Sorry Komusu

Welcome but no one can help you because:-


Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Click on Edit to open your thread, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

Untested, but give this a try:

Please Login or Register  to view this content.

keep in mind that your code is not removing existing comments, and will error out if the cell has a comment already.

Yes, I tried on empty cells but I get this: We looked at all the data next to your selection and didn't see a pattern for filling in values for you.

That sounds like a Flash Fill message to me, unrelated to the code for comments.

So you just run Arkadi's code exactly as posted and that error occurs?

I don't currently have access to a version of Excel with Flash Fill to test, but I genuinely cannot see how that code could trigger it.

It worked, I tried it on different excel and it worked. Thanks. I have one more question.
Is it possible to paste my clipboard but after "Author" before every comment, it will be the same for every comment, just the clipboard will be different. It will be like in the code "& "tm"" but before mystring. Thanks so much

Something like this

Please Login or Register  to view this content.

Edit:

Please Login or Register  to view this content.

I used this code it worked fine, but when I closed excel and open it again, the macro wasn't there and when I create the same macro I get this error "user-defined type not defined"

Help please

Quite possibly you had a userform in the original file, and not when you made the new one. I overlooked the fact that on a new book, you need to add a reference for this to work.

In VBA Editor, Click on Tools, then References... and put a checkmark in the box next to Microsoft Forms 2.0 Object Library... then the error about user-defined type not defined will go away.

Originally Posted by Arkadi

Quite possibly you had a userform in the original file, and not when you made the new one. I overlooked the fact that on a new book, you need to add a reference for this to work.

In VBA Editor, Click on Tools, then References... and put a checkmark in the box next to Microsoft Forms 2.0 Object Library... then the error about user-defined type not defined will go away.

Thanks for reply, but I am not able to find Microsoft Forms 2.0 Object library in References

Edit: Somehow i added it after I click insert user form and closed it because I didn't know what to do. And then I saw it's in references and now the code it's working.

Insert a userform and then delete. That's the quickest way to add the reference. Alternatively, you can late bind the code so that you don't require the reference at all.

Replace the first two lines with these

Please Login or Register  to view this content.