simora
12-27-2009, 11:04 PM
In Textbox 6 of my Excel Userform, I want to enter comments and enter those comments in Column FU.
The Row# depends on the Agent selected in ComboBox 1 = .rsRow
How do I show any comments that are already enterred from a previous encounter in Textbox6 when I start the UserForm, and allow any additional comments to be added to the existing comments in Column FU ( Column 175) when additional data is entered in Textbox6.
I can currently post data to the correct location, but cant add to existing comments or show what's already there.
This code correctly post original comments.
If TextBox6.Value <> "" Then
Cells(rsRow, 175).AddComment
Cells(rsRow, 175.Comment.Visible = False
Cells(rsRow, 175).Comment.Text Text:=strTime & ":" & Chr(10) &_ strDate & Chr(10) & "Today's Comments " & "" & TextBox6.Value
Cells(rsRow, 175).Comment.Shape.TextFrame.AutoSize = True
End If
Any suggestions and help appreciated.
Thanks
The Row# depends on the Agent selected in ComboBox 1 = .rsRow
How do I show any comments that are already enterred from a previous encounter in Textbox6 when I start the UserForm, and allow any additional comments to be added to the existing comments in Column FU ( Column 175) when additional data is entered in Textbox6.
I can currently post data to the correct location, but cant add to existing comments or show what's already there.
This code correctly post original comments.
If TextBox6.Value <> "" Then
Cells(rsRow, 175).AddComment
Cells(rsRow, 175.Comment.Visible = False
Cells(rsRow, 175).Comment.Text Text:=strTime & ":" & Chr(10) &_ strDate & Chr(10) & "Today's Comments " & "" & TextBox6.Value
Cells(rsRow, 175).Comment.Shape.TextFrame.AutoSize = True
End If
Any suggestions and help appreciated.
Thanks