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
|