Thread: Displaying cell comments.
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
K Dales[_2_] K Dales[_2_] is offline
external usenet poster
  
Posts: 1,163
Default Displaying cell comments.
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Range("B4").Comment.Visible = Not (Intersect(Target, Range("B4")) Is
Nothing)
End Sub

--
- K Dales


"Dan N" wrote:

How do I make a cell display the cell comments only when the cell is active?
I am using Excel 2000.
Reply With QuoteReply With Quote