Programming Comments in Excel 2007

[jon_porter]

Hello all,

I am looking for a code that will create a comment within the highlighted cell including the name and date/time that it was created. In addition to this I would like the code to allow another comment to be inserted by another user at a later date with the same formatting of username/date/time in the line beneath the first comment. And for this process to be repeatable.

Is it also posible to have this comment box resizeable after each comment is added, and be available for use in a shared workbook?

Many Thanks All.

Jon

[Andy Pope]

You don't say how the macro is trigger or the user enters the actual comment text.

In a standard code module.

Please Login or Register  to view this content.

[jon_porter]

I have a button ready to attach the macro to. I was hoping that a text box or something similar would appear and allow the user to input their comment, with the comment then appearing beneath the time, date and username of the person that entered the comment. With this being repeatable using the same macro, so that if the highlighted cell already contains a comment then when a new comment is inputed using macro the date/time/username apears again with the new comment beneath the 1st.

Thanks,

Jon

[Andy Pope]

You can use a input box or userform to capture users comment text.