Cel Content

N

Nadine

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
 
G

Gord Dibben

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top