Ability to filter comments in Excel

[ogre2673]

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

[Barb Reinhardt]

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

"ogre2673" <[email protected]> wrote in message
news:[email protected]...
>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

[Debra Dalgleish]

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" <[email protected]> wrote in message
> news:[email protected]...
>
>>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

[Dave Peterson]

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