Saving large text field in a cell; making it pop-up

[Jim]

I want to put a block of text (100-300 characters) in a cell; the text may
consist of multiple lines.

I would like the to be able to keep the cell small (one text line high) when
the cell in not selected but see the whole text block when the cell is
selected ( or moused-over).

2 questions:
Is there a way to make the entire contents of a cell 'pop up' when the cell
is selected?

Is there a way to have accept newlines (when pasting) rather than moving
down to the next cell. (putting in Alt-Enter by hand is a drag).

Thanks,

Jim Cant

 

[Brad]

I dont know of a way to capture the mouseover event in
excel.

But perhaps this code would suffice for what you're
looking for regarding selecting cells..?

Private Sub Worksheet_SelectionChange(ByVal Target As
Range)
Static rng As Range
' if rng hasn't been initialized..
If rng Is Nothing Then
Set rng = Target
End If
' previous cell needs to have word wrap removed.
rng.WrapText = False

' make the current cell have word wrap.
Target.WrapText = True
' update static variable
Set rng = Target
End Sub

Also comments pop up when a cell is selected, if you want
to go that bizarre route!

-Brad

 

[jasonsweeney]

Jim,

You may also want to check out data valuation, entering an inpu
message.

click on a cell>Click Data>Validation>Input Message

then type your message. You ARE limited to the amount of text to ente
into the input message box.

Note you can program what goes into the input message via code. To ge
started, use the macro recorder to see the basics.

Debra Dalgleish's site has some great examples of this and use o
comments...

See for issues re Validation:
http://www.contextures.com/xlDataVal04.html

See for issues re Comments:
http://www.contextures.com/xlcomments01.htm