Excel 2007 : Only showing some text

**Django** · 11-03-2010, 10:17 AM

I have a lot of text that I want to put into a cell. I don't want to change the cell width or height, so word wrap is out. I also don't want to shrink the text. What I'm hoping for here is to enter the text and, no matter how much I've typed, it'll just show however much of the text as will fit in the cell as it is and the rest will be revealed with a mouseover. I don't want to use comments, either (I'm trying to pre format a sheet for an employee who will have to do this regularly) I would really appreciate any help that anyone can offer.

**Marcol** · 11-03-2010, 10:44 AM

Hi Django

Welcome to the forum

As far as I am aware excel sheets don't have a mouse-over event.

You could try this with a Label or TextBox, and a variation of this code in the worksheet selection change event.

Option Explicit

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    If Target.Address = "$A$2" Then
        Label1 = Target
        Label1.Visible = True
    Else
        Label1.Visible = False
    End If
End Sub

Click in and out of cell A2 to see the result.

Hope this helps