Show a comment

How to show a comment using the Excel, VBA and Shortcut methods

METHOD 1. Show a comment using cell option

EXCEL

Right-click on a cell > Click Show/Hide Comments

1. Right-click on the cell that has the comment that you want to show.
2. Click Show/Hide Comments.
Note: in this example we are showing a comment in cell B2. 		Right-click on a cell and click Show Hide Comments

METHOD 2. Show a comment using ribbon option

EXCEL

Select the cell > Review tab > Comments group > Click Show/Hide Comment

1. Select the cell that has the comment that you want to show.
Note: in this example we are showing a comment in cell B2. 		Select a cell that has the comment that you want to show

2. Select the Review. Select the Review tab

3. Click Show/Hide Comment in the Comments group. Click Show/Hide Comment

METHOD 1. Show a comment using VBA

VBA

Sub Show_Comment()
'show a comment in cell ("B2")

Worksheets("Analysis").Range("B2").Comment.Visible = True

End Sub

OBJECTS
Worksheets: The Worksheets object represents all of the worksheets in a workbook, excluding chart sheets.
Range: The Range object is a representation of a single cell or a range of cells in a worksheet.
PREREQUISITES
Worksheet Name: Have a worksheet named Analysis.

ADJUSTABLE PARAMETERS
Cell in which to show a comment: Select the cell in which to show a comment by changing the cell reference ("B2") in the VBA code to any cell in the worksheet that has a comment.
Worksheet Selection: Select the worksheet in which you want show a comment by changing the Analysis worksheet name, in the VBA code, to any worksheet in the workbook.

Explanation about how to show a comment

EXPLANATION

EXPLANATION
This tutorial explains and provides step by step instructions on how to show a comment using the Excel, VBA and Shortcut methods.

Excel Methods: Using Excel you can show a comment in the selected cell with the ribbon option or cell option.

VBA Methods: Using VBA you can show a comment in a cell that has been specified in the VBA code.