VBA For Comments

[MikeG]

I would like it so that when a user presses ctrl m, a macro will be activated that reads any comment that is in the current cell, displays this in a user form, allows the user to edit the comment, then puts the new comment in place when the user hits OK?

I wonder if anyone could help.

Thanks,

MikeG

 

[MikeG]

Sorry for all the self-replies.

Finally, I did it with:


ActiveCell.NoteText Text:=TextBox1.Text

Thanks

MikeG