Add coments VBA

[lasher18]

Hi,
I am trying to make a macro that insert automaticlly a comment if a cell match a certain condition. If there is a cell with the value "o" it should appear a comment box.
So far I got this:

Please Login or Register  to view this content.

Can you help me ?

thanks

[Kaper]

Please Login or Register  to view this content.

If there are comments already you may for instance override adding by

Please Login or Register  to view this content.

[lasher18]

Hi,
thanks for your prompt reply, it returns me the following error in the capture attached

Regards,

[Kaper]

I've shown only the middle part to be inserted in your code. The whole sub could read:

Please Login or Register  to view this content.

[lasher18]

where could be the mistake?

[bakerman2]

Check if the sheetname is correct then try this way.

Please Login or Register  to view this content.

[lasher18]

Thanks guys,
would there be some way to do it without having to run the macro every time? in the sense that every time an employee enters an "o" a new comment is automatically generated. Could be with an event like Worksheet_SelectionChange instead of sub?

[Kaper]

Yes, it could.

But observing problems with the implementation - I'd strongly recommend following the hint from a yellow banner above.



Anyway, let's try. The code for the Change event handler in a sheet (right click on the sheet name tab and select view code):

Please Login or Register  to view this content.

[lasher18]

Thank you!!
just one more point: it would be ideal to not show all the comments at the same time, just the one in the cell selected.
This I know can be achieved writting: .Comment.Visible = False ,but in this way it does not allow me to edit the comment. I'd need both see the comment just in the selected cell and able to edit it.

Would be target.comment.visible=true ?

I attached you the template with the code this time.

thanks a lot

[bakerman2]

Please Login or Register  to view this content.

[lasher18]

Amazing, thanks very much man

[bakerman2]

You're welcome and thanks for rep+.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.