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.

Select the cell and :
Insert Comment
--
Gary''s Student - gsnu200764


"JTMateo45" wrote:

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.

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

"Gary''s Student" wrote:

Select the cell and :
Insert Comment
--
Gary''s Student - gsnu200764


"JTMateo45" wrote:

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.

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.
--
Gary''s Student - gsnu200764


"JTMateo45" wrote:

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

"Gary''s Student" wrote:

Select the cell and :
Insert Comment
--
Gary''s Student - gsnu200764


"JTMateo45" wrote:

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.

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

"Gary''s Student" wrote:

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.
--
Gary''s Student - gsnu200764


"JTMateo45" wrote:

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

"Gary''s Student" wrote:

Select the cell and :
Insert Comment
--
Gary''s Student - gsnu200764


"JTMateo45" wrote:

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.