| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell Comments
Is there a way to show a comment only when the corresponding cell is selected?
|
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Cell Comments
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Dim C As Comment For Each C In ActiveSheet.Comments C.Visible = (C.Parent.Address = Target.Address) Next C End Sub "LDanix" wrote: Is there a way to show a comment only when the corresponding cell is selected? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Cell Comments
Not a comment I don't believe (I assume you are unhappy with the default
behavior), but perhaps you could use data validation. It has several options for popping up messages. -- Regards, Tom Ogilvy "LDanix" wrote in message ... Is there a way to show a comment only when the corresponding cell is selected? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Extract Cell Comments and Paste as text in a cell | Excel Worksheet Functions | |||
| excel 2000 how to format the comments font all comments | Excel Discussion (Misc queries) | |||
| Comments into a cell without VB. | Excel Discussion (Misc queries) | |||
| print comments using cell contents, not cell# | Excel Discussion (Misc queries) | |||
| Need to add cell comments in unlocked cell on protected worksheet | Excel Discussion (Misc queries) | |||
Linear Mode
