We can add comments to a range using VBA. When you are automating any task you may wants to write the comments dynamically based on the data. You can use Range.AddComment method to insert a comment to a particular range or a cell. The below example macro codes will show you – how to add or insert comments using VBA in Excel 2003,2007,2010,2013 or higher.

VBA AddComment Method Excel Range Object

Why we need to add comments using VBA

When we are automating any Excel task or preparing the Excel templates, it is better idea to provide enough information to the user. In some cases, the actual Cell or Range may not be sufficient to show the information, or you may want to show the additional information to the user or client (like instructions, help, or about the field, or you may want to to describe more about some data in a range or cell. Adding comments will be a good idea to provide such information, this will also help your worksheet looks more cleaner as comments will not appear until your user or customer hover on the cell or a range.

VBA Add Comments in an Excel Range – Syntax

You can use the below syntax or Macro Code to add or insert comments to a range in Excel using VBA.

Range(“YourRange”).AddCommnet “Your Text”

VBA to Add Comments in an Excel Range – Examples

Please look into the below examples will show adding comments in different situations while automating your tasks.

VBA to Add Comments in an Excel Range – Simple Example

The below example will show you how to add a comment at Range “A2” as ‘Hello, this is a comment text’:

Range("A2").AddComment "Hello, this is a comment text"

Here AddComment is method of an Excel Range to add the comments. And ‘A’ is the Column Name and ‘2’ is the Row number.

VBA to Add Comments in an Excel Range – Instructions

  1. Open an Excel Workbook from your start menu or type Excel in your run command
  2. Press Alt+F11 to Open VBA Editor or you can goto Developer Table from Excel Ribbon and click on the Visual Basic Command to launch the VBA Editor
  3. Insert a Module from Insert Menu of VBA
  4. Copy the above code for adding or inserting c comment into a range and Paste in the code window(VBA Editor)
  5. Save the file as Macro Enabled Workbook (i.e; .xlsm file format)
  6. Press ‘F5′ to run it or Keep Pressing ‘F8′ to debug the code line by line.

Now you can observe that a new comment is added at Range A2 as “Hello, this is a comment text”.

Real-time Applications on VBA AddComment to a Range Method

  • How to use Project plan template Excel Template

How to Use Project Plan Template

Here are the step by step instruction to use Excel Project Plan Template. You can download our free Project Plan Template and follow the below instruction to plan your projects. Overview Project Plan template contains [...]

  • ActiveSheet VBA in Excel

VBA ActiveSheet – Excel Active Sheet Object

VBA ActiveSheet Object helps to refer the currently activated sheet in the active workbook. We can get all properties and methods of the ActiveSheet using VBA. Let us see the useful of the examples on [...]

Excel VBA ColorIndex

VBA ColorIndex Property of Excel VBA is very useful to set the fill colors, border colors and font colors. Excel VBA ColorIndex returns index values from 1 to 56, -4105 and -4142. You can set [...]

120+ Professional Project Management Templates!
Save Up to 85% LIMITED TIME OFFER

A Powerful & Multi-purpose Templates for project management. Now seamlessly manage your projects, tasks, meetings, presentations, teams, customers, stakeholders and time. This page describes all the amazing new features and options that come with our premium templates.

Browse All Templates
Excel VBA Project Management Templates

All-in-One Pack
120+ Project Management
Premium Templates
View Details

Essential Pack
50+ Project Management
Premium Templates
View Details
50+ Excel
Project Management
Templates Pack
View Details
50+ PowerPoint
Project Management
Templates Pack
View Details
25+ MS Word
Project Management
Templates Pack
View Details
Ultimate Project Management Template
View Details
Ultimate Resource Management Template
View Details
Project Portfolio Management Templates
View Details

Share This Story, Choose Your Platform!

One Comment

  1. MS office Support September 13, 2018 at 1:05 PM

    Nice Article! I am glad to know about VBA Add Comments to Excel Range. I often work on excel sheet so it is really helpful for me. Thank you for this information.

Leave A Comment