Adding a comment to a excel using VBA

Question

I'm having real difficulties adding a comment to a cell.

I'm calling the following sub

Sub ValidationError(row As Long, column As Integer, ErrorLine As String)

Tabelle1.Cells(row, column).Interior.Color = vbYellow
Tabelle1.Cells(row, column).AddComment ErrorLine

End Sub

But I always get a 1004 error, saying "Application or object error" (this is translated, original message: "Anwendungs- oder objektdefinierter Fehler")

The sub is called using

Call ValidationError(8, 9, "Text string")

What am I doing wrong?

Best

hello can you please try this: Tabelle1.Cells(row, column).AddComment Text:=ErrorLine — Dubison
– Dubison, Commented Feb 13, 2015 at 7:55

BrakNicku · Accepted Answer · 2015-02-13 08:08:09Z

13

Your code should work if the target cell does not contain a comment. You can change the procedure to clear existing comments first:

Sub ValidationError(row As Long, column As Integer, ErrorLine As String)

Tabelle1.Cells(row, column).Interior.Color = vbYellow
Tabelle1.Cells(row, column).ClearComments
Tabelle1.Cells(row, column).AddComment ErrorLine

End Sub

answered Feb 13, 2015 at 8:08

BrakNicku

6,0313 gold badges28 silver badges40 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Adding a comment to a excel using VBA

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related