Forum Discussion

maxwelli1970's avatar
maxwelli1970
Copper Contributor
Jun 20, 2019

adding a comment to a cell from a textbox in a userform

Hi,        I'm designing a simple tracking system to aid training. I have most of the form dealt with but I'm struggling with a certain component. I need a text box within the user form to input the...
excel
Formulas and Functions
Macros and VBA
Haytham Amairah's avatar
Haytham Amairah
Silver Contributor
Jun 23, 2019

maxwelli1970

 

It's fairly easy, please check out this example below and find it in the attached file.

 

Private Sub CommandButton1_Click()
 On Error Resume Next
 Dim com As String
 com = TextBox1.Text

  With ActiveCell
   .AddComment
   .comment.Visible = False
   .comment.Text Text:="Input Tracking Data:" & Chr(10) & com
  End With
 On Error GoTo 0
End Sub

 

 

Hope that helps

Resources