Cell Comments

[jspattavina]

I want to be able to display the active cell comment in a form text box
if you change to the text box it will update the comment

 

[Jeffrey Mahoney]

Well, a regular textbox inserted onto the sheet could do that. A form textbox only updates when you load the form or manually tell the control to update or unless you build in VBA code to update the textbox control each time the cell has changed.

Or are you wanting a Form textbox to change the cell comment (now called cell note). If so, then use these two Subs to do that

Private Sub TextBox1_BeforeUpdate(ByVal Cancel As MSForms.ReturnBoolean)
  Sheets("Sheet1").Range("G5").Comment.Text Text:=TextBox1.Value
End Sub


Private Sub UserForm_Initialize()
  TextBox1.Value = Sheets("Sheet1").Range("G5").Comment.Text
End Sub