Cut EDIT COMMENT from active cell and paste into userform

[alecwarner]

Is it possible (with VBA) to "cut" the contents of the EDIT COMMENT box from the active cell and paste these into a USERFORM TEXT BOX?

Thanks

Al

 

[My Aswer Is This]

This will insert the comment in the active cell to textbox1 of your UserForm
And Delete the comment from the active cell:

Private Sub CommandButton1_Click()
TextBox1.Value = ActiveCell.Comment.Text
ActiveCell.Comment.Delete
End Sub