Creating a user friendly comment section

[KlaasE]

Hi everyone,

I haven't exactly got a technical problem (yet) with what I'm making. What I've been doing is make a comment section in a work document where people from different departments can add comments. What I made so far is this:

A textbox with comments, that can be filled with this userform:

If some one would like to add a comment to the document, they can press the big comment button and the Userform appears. They'll have to select their initials from the listbox and enter the comment in the textbox next to it. When finished they press the button and it will be copied to the textbox on the sheet.

Now it works fine, as long as no one makes a typo or needs a comment to be deleted. Right now if they want to delete something, they will send me an email or come to my desk to have me delete it. Rather inefficient.

So here is my question: is there a user friendly way that I can let the users remove their own comments, or should I change my whole 'comment section' to make that possible? I'm not an expert on excel, so my main problem is not knowing all the possibilities.
Also worth mentioning, most of the users are very incompetent with excel and computers in general, so for them it needs to be fool proof.

Thanks for any advice!

 

[offthelip]

if you want to only permit a user to edit or delete their own comments then you are going to need to store their username with the comments, see application.username property, so I think you are going to have to modify your current comment system.