Programming Excel with VBA and .NET

Name

range.AddComment( )

Synopsis

Adds a comment to the specified range. The following code adds a comment to cells with batting averages .300 and over:

Dim r As Range
Dim rwIndex As Integer
 
For rwIndex = 1 To 3
    Set r = Worksheets("WombatBattingAverages").Cells(rwIndex, 2)
    With r
         If .Value >= 0.3 Then
              .AddComment "All Star!"
         End If
    End With
Next rwIndex