Hi, apologies if I'm posting an already existing topic but I did a quick search and couldn't find anything similar so....

What I need to do is this...

I have a holiday / visit planner and would like to add some functionality so the user can double click on a particular cell (corresponding to a date) and a userform text box will open up to enable him / her to enter some comments. Once done the user can click an OK button which transfers the text into the cell comments area.

I have the worksheet protected so the users cannot enter comments with the usual 'insert comment' method.

any ideas? thanks!