Cel Content
 

hi

text in cel is wrapped
i want the cel height to be fixed and then when i am in the cel have the
entire contents appear as a pop up of in full

I realize it shows at the top of the sheet
but isn't there a way to view it on the sheet ?

or link to another sheet to view the entry without exploding my format sheet?

thanks
Nadine

Cel Content
 

The only way I can think of is to replicate the entry as a comment in the cell.
--
Kevin Backmann


"Nadine" wrote:

hi

text in cel is wrapped
i want the cel height to be fixed and then when i am in the cel have the
entire contents appear as a pop up of in full

I realize it shows at the top of the sheet
but isn't there a way to view it on the sheet ?

or link to another sheet to view the entry without exploding my format sheet?

thanks
Nadine

Cel Content
 

Ohhh that is a great idea !!!
thanks Kevin

Nadine


"Kevin B" wrote:

The only way I can think of is to replicate the entry as a comment in the cell.
--
Kevin Backmann


"Nadine" wrote:

hi

text in cel is wrapped
i want the cel height to be fixed and then when i am in the cel have the
entire contents appear as a pop up of in full

I realize it shows at the top of the sheet
but isn't there a way to view it on the sheet ?

or link to another sheet to view the entry without exploding my format sheet?

thanks
Nadine

Cel Content
 

If you have many of these to do a macro is nice.

Sub Comment_Add()
Dim cmt As Comment
Dim r As Range
For Each r In Range("D3:D100") 'adjust to suit
Set cmt = r.Comment
If cmt Is Nothing Then
Set cmt = r.AddComment
cmt.Text Text:=r.Text
End If
Next r
End Sub


Gord Dibben MS Excel MVP

On Thu, 14 Aug 2008 11:23:00 -0700, Nadine
wrote:

Ohhh that is a great idea !!!
thanks Kevin

Nadine


"Kevin B" wrote:

The only way I can think of is to replicate the entry as a comment in the cell.
--
Kevin Backmann


"Nadine" wrote:

hi

text in cel is wrapped
i want the cel height to be fixed and then when i am in the cel have the
entire contents appear as a pop up of in full

I realize it shows at the top of the sheet
but isn't there a way to view it on the sheet ?

or link to another sheet to view the entry without exploding my format sheet?

thanks
Nadine