Ability to filter comments in Excel
 

I would like to have the ability to filter rows that include comments. In
the custom filter box, options such as "Include Comments" or "Comments Only"
would be helpful.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...el.programming

Ability to filter comments in Excel
 

Why not use AUTOFILTER and select the NON-BLANKS in the column.

"ogre2673" wrote in message
...
I would like to have the ability to filter rows that include comments. In
the custom filter box, options such as "Include Comments" or "Comments
Only"
would be helpful.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow
this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...el.programming

Ability to filter comments in Excel
 

An AutoFilter for Non-Blanks would show cells with data, but not cells
with comments (Insert Comment)

Barb Reinhardt wrote:
Why not use AUTOFILTER and select the NON-BLANKS in the column.

"ogre2673" wrote in message
...

I would like to have the ability to filter rows that include comments. In
the custom filter box, options such as "Include Comments" or "Comments
Only"
would be helpful.

--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Ability to filter comments in Excel
 

I read your post that you wanted to filter on the actual comment itself.

If that's the case, you could use a userdefined function to retrieve the
comment's text and put it into an adjacent cell. Then filter by that.

If that's ok...

Saved from a previous post:

You can retrieve the text from a comment with a userdefined function like:

Option Explicit
Function GetComment(FCell As Range) As Variant
Application.Volatile

Set FCell = FCell(1)

If FCell.Comment Is Nothing Then
GetComment = ""
Else
GetComment = FCell.Comment.Text
End If

End Function

Then you can use it like any other function:

=getcomment(a1)

But be aware that the function won't evaluate when you just change the comment.
It'll be correct when excel recalculates. (Hit F9 to force a recalc.)

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm


ogre2673 wrote:

I would like to have the ability to filter rows that include comments. In
the custom filter box, options such as "Include Comments" or "Comments Only"
would be helpful.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...el.programming

--

Dave Peterson