show contents of cell when hovering

[mikeha_99]

Hello,
I have a cell with lengthy text in it, and I do not want to change the height and width of the cell. I would like all the text to be visible when I hover the mouse over the cell.

I do not want to have to select the cell, or view the cell contents in the formula bar, or insert a comment. Just view all text when hovering over the cell.

Is this possible? If so, please indicate how I would do this.

Thanks,
Mike

 

[Jaafar Tribak]

Hello,
I have a cell with lengthy text in it, and I do not want to change the height and width of the cell. I would like all the text to be visible when I hover the mouse over the cell.

I do not want to have to select the cell, or view the cell contents in the formula bar, or insert a comment. Just view all text when hovering over the cell.

Is this possible? If so, please indicate how I would do this.

Thanks,
Mike

Any reason why not use a comment. It seems to me the ideal solution for your problem.

 

[mikeha_99]

I do not want to use the comment feature. We have two viewing scenarios. In one case, the single user can expand the size of the column to see the entire text. In the other case, we are viewing as a group with a projector. Then this column needs to be reduced in width.

Since we may need to see some of the text in question, I do not want to be expanding and then shrinking the column throughout the meeting. If we need to see the text, I would rather just move the mouse over it to see it (we are in Full Screen mode, and there is no formula bar).

Keep in mind, when not in this group viewing mode, the column width is expanded as needed.

Thanks,
Mike

 

[wut]

Select the cell and set an accelerator that calls a macro to return a message box with the contents of the active cell?

 

[Jaafar Tribak]

I do not want to use the comment feature. We have two viewing scenarios. In one case, the single user can expand the size of the column to see the entire text. In the other case, we are viewing as a group with a projector. Then this column needs to be reduced in width.

Since we may need to see some of the text in question, I do not want to be expanding and then shrinking the column throughout the meeting. If we need to see the text, I would rather just move the mouse over it to see it (we are in Full Screen mode, and there is no formula bar).

Keep in mind, when not in this group viewing mode, the column width is expanded as needed.

Thanks,
Mike

There is no mouse over event for worksheet cells. You can code it but it is not an easy task. ( See if you can adapt this workbook demo )

I still don't understand why you don't want to use a comment for this. You can have a comment set to be hidden and make it appear only when moving the mouse over the commented cell.

 

[mikeha_99]

Regarding why I don't want to use "insert comment" for this problem.

I need to be able to use "Find" to locate key words in the sheet. I don't believe this works with the inserted comments. Additionally, I want to be able to view the entire column and all contents while I'm editing.

During a meeting, I run in Full Screen display mode, and there is no formula bar. The cells in question are in a column kept narrow for display purposes. Rather than expanding temporarily, then shrinking the width again, I would like to see the entire cell contents with a Mouse Over (or anything similar, what if I select the cell??).

If it were just for myself, I could deal with this issue, but I'm not the only user. Frankly, many Excel users barely understand the basics, and do not move around comfortably within all that Excel is capable of. To ease this issue, I try to make the spreadsheet simple (though simple to use might equate to complicated for me to build).

Thanks everyone for their input so far.

Mike

 

[wut]

I don't know how to do what you want. So all I can do is keep throwing out suggestions. If a messagebox wouldn't work for you, then you could try having a macro that autopopulates a cell which you keep expanded to the right side of the sheet with what ever the contents of the active cell are. You could have the contents of the original cell reformatted once they reach their destination.

 

[ChrisOswald]

Here's my 2 cents.

The display format of comments seems to be exactly what you want. However, you're worried that you aren't going to be able to Ctl-F to quickly locate cells. You can use code to add comments such that they have either the value of the cell or the formula in the cell. The first one is currently set to show the formula if a cell has one; otherwise it'll show the cells text.

Sub CommentTheHeckOuttaIt()
    Dim WS                          As Worksheet
    Dim iCell                       As Range
    For Each WS In ActiveWorkbook.Worksheets
        For Each iCell In WS.UsedRange
            With iCell
                If CStr(.Value) <> "" Then
                    .ClearComments
                    .AddComment
                    .Comment.Visible = False
                    .Comment.Text Text:=CStr(.Value)
                    .Comment.Shape.ScaleWidth 5.87, msoFalse, msoScaleFromTopLeft
                    .Comment.Shape.ScaleHeight 2.26, msoFalse, msoScaleFromTopLeft
                End If
                If .Formula <> "" Then
                    .ClearComments
                    .AddComment
                    .Comment.Visible = False
                    .Comment.Text Text:=CStr(.Formula)
                    .Comment.Shape.ScaleWidth 5.87, msoFalse, msoScaleFromTopLeft
                    .Comment.Shape.ScaleHeight 2.26, msoFalse, msoScaleFromTopLeft
                End If
            End With
        Next
    Next
End Sub
 
 
 
Sub AllCommentsMustDIE()
    Dim WS                          As Worksheet
    Dim iCell                       As Range
    For Each WS In ActiveWorkbook.Worksheets
        For Each iCell In WS.UsedRange
            iCell.ClearComments
        Next
    Next
End Sub

For demo purposes, you could run the first macro. when finished with the demo, you run the second macro.
Try them out on a copy of your workbook.

 

[Jaafar Tribak]

Regarding why I don't want to use "insert comment" for this problem.

I need to be able to use "Find" to locate key words in the sheet. I don't believe this works with the inserted comments. Additionally, I want to be able to view the entire column and all contents while I'm editing.

Mike.

You should be able to use the Find feature while you have cell comments.

I wasn't suggesting putting the text inside the comment and leaving the corresponding cell empty.

What you should do is leave the cell with its text as is and duplicate the same text in the cell comment. Resize the comment window to fit the whole text and set the comments to hidden so that whenever you move the mouse over the cell , the whole cell text will show up inside the comment.

 

[mikerickson]

When I look at the Find dialog box, Look In has three options: Formulas, Values and Comments.

Excel 2004