Just a quick question.

Everytime mouse curser is on the cell the comments window appears.
have a lot of comments on a lot of cells.
I want excel to show me comments ONLY when I select on the cell.

Is it possible?

NYBo

--
NYBo
-----------------------------------------------------------------------
NYBoy's Profile: http://www.excelforum.com/member.php...nfo&userid=836
View this thread: http://www.excelforum.com/showthread.php?threadid=47293

One way is to use a worksheet event:

Option Explicit
Private Sub Worksheet_SelectionChange(ByVal Target As Range)

Dim myCell As Range
'turn off the comment indicator
Application.DisplayCommentIndicator = xlNoIndicator

For Each myCell In Target.Cells
If myCell.Comment Is Nothing Then
'do nothing
Else
myCell.Comment.Visible = True
End If
Next myCell
End Sub

Rightclick on the worksheet tab that should have this behavior and select view
code. Paste this in and try selecting different cells.



NYBoy wrote:
>
> Just a quick question.
>
> Everytime mouse curser is on the cell the comments window appears. I
> have a lot of comments on a lot of cells.
> I want excel to show me comments ONLY when I select on the cell.
>
> Is it possible?
>
> NYBoy
>
> --
> NYBoy
> ------------------------------------------------------------------------
> NYBoy's Profile: http://www.excelforum.com/member.php...fo&userid=8360
> View this thread: http://www.excelforum.com/showthread...hreadid=472935

--

Dave Peterson

Thanks Dave.

You guys are amazing. I don't know how you do these codes but they
work.
I'm an aircraft engineer but I think you guys know all the secrets.

Thanks again,
NYBoy


--
NYBoy
------------------------------------------------------------------------
NYBoy's Profile: http://www.excelforum.com/member.php...fo&userid=8360
View this thread: http://www.excelforum.com/showthread...hreadid=472935

Another option, where there is *no* indication that a comment is even
present ... until the cell is selected ... is to use the
<Data> <Validation> <InPut Message> tab.

--

Regards,

RD
----------------------------------------------------------------------------
-------------------
Please keep all correspondence within the Group, so all may benefit !
----------------------------------------------------------------------------
-------------------


"NYBoy" <(E-Mail Removed)> wrote in
message news:(E-Mail Removed)...

Thanks Dave.

You guys are amazing. I don't know how you do these codes but they
work.
I'm an aircraft engineer but I think you guys know all the secrets.

Thanks again,
NYBoy


--
NYBoy
------------------------------------------------------------------------
NYBoy's Profile:
http://www.excelforum.com/member.php...fo&userid=8360
View this thread: http://www.excelforum.com/showthread...hreadid=472935