Exploded cell view/comment

J

JTMateo45

I am tryint to format a cell so that when you mouse over it, a "comment" like
box appears that you can type in instead of typing in the actual box. Please
comment if you can help.
 
J

JTMateo45

What im trying to do is format the cell so that when someone mouses over the
cell it automatically pops up a comment box that they can edit/add to.
Basically taking the "insert comment" step out of it and allowing them to
come back and change the comment by simply clicking on it.

Thanks in advance
 
G

Gary''s Student

I wish I could help you. I have not had any luck trapping mouse_over.

Oviously Excel knows the mouse is hovering above a cell, because it makes a
comment visible. I don't know if this status is available to the programmer.
 
J

JTMateo45

i ended up making a macro that auto comments whatever is typed into the cell

(worksheet)

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
FillComments
End Sub

(General)

Option Explicit

Sub FillComments()
On Error Resume Next
Dim RangeAddress As String
Dim Notes As Range
Dim NoteCell As Range

RangeAddress = "c9:ag9,c15:ag15,c21:ag21"

Set Notes = ActiveSheet.Range(RangeAddress)
For Each NoteCell In Notes.Cells
If Len(NoteCell.Value) > 0 Then
NoteCell.AddComment
NoteCell.Comment.Text Text:=NoteCell.Value
Else
NoteCell.Comment.Delete
End If
Next

End Sub
 
Top