View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
CLR CLR is offline
external usenet poster
 
Posts: 594
Default Show Comment when in the cell

This one will toggle it on and off with each selection of the cell.

Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
On Error Resume Next
If ActiveCell.Comment.Visible = True Then
ActiveCell.Comment.Visible = False
Else
ActiveCell.Comment.Visible = True
End If
End Sub

hth
Vaya con Dios,
Chuck, CABGx3


"Manju" wrote in message
ps.com...
Is it possible to make a comment appear when the keyboard cursor goes
to that particular cell instead of mouse moving on to the cell?
Manju