Macro to add a comment to a cell via a text entry box from a user form

Hi There

I am using Excel 2010 in a windows 7 environment.

I am trying to write a macro that will allow me to do the following.

I have created a user form for data entry. On the user form I have a text entry box that I would like the user to complete and when submitted, the text in the box will show as a comment on the respective cell in the worksheet??

I have looked through the forum and Google to see if there is any type of code out there but to no avail.

Any offers or advise for help is gratefully received

Steve

Hi There

Thanks for the quick reply.

The codes says "ActiveCell" what if I had a text box linked to a specific cell on a specific worksheet. How would that change your code??

Steve

Hey Buddy. That worked brilliantly. Thanks ever so much.

Steve