Comments Display Error

**Launchnet** · 04-13-2008, 07:26 PM

On my workbook I am using Comments to show others how to do it.

Problem: When I insert a comment into a cell that is close to the right side of the computer screen, part of the comment is hidden to the right.

I've looked at all the setting on formatting "Comments" and I can not find a way to change where the comments box will be displayed.

Does anyone know if there is anyway to keep the "Comments Box" within the computer screen so all of the "Comments" can be read.

**Simon Lloyd** · 04-13-2008, 08:57 PM

Look here at Chip Pearsons site for some useful code on zoom http://www.cpearson.com/excel/zoom.htm

**Launchnet** · 04-13-2008, 11:18 PM

Thanks for the suggestion. It doesn't do what I need. I have more than 1 comment in diffeent cells and this wouldn't work.

Thanks for your suggestion.
Still Looking

**Simon Lloyd** · 04-14-2008, 12:08 AM

How about this then?

Code:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    Dim MyCom As Comment
    On Error Resume Next
    Set MyCom = Target(1, 1).Comment
    If Target.Column >= 11 Then 'change to suit last but one visible column
    If Not MyCom Is Nothing Then Application.Goto Target(1, 1), True
    End If
End Sub

**davesexcel** · 04-14-2008, 12:08 AM

Originally Posted by Launchnet

Thanks for the suggestion. It doesn't do what I need. I have more than 1 comment in diffeent cells and this wouldn't work.

Thanks for your suggestion.
Still Looking

It probably is not possible without VBA, but another way the create comments is with data Validation
Select a cell,then Go to
Data
Validation
Select input message tab
Add Title
Input message
Make sure the check box is checked to show message when cell is selected
then click OK
I have seen the message always show when that cell is selected using data validation

**Launchnet** · 04-14-2008, 01:17 AM

Dave, I tried your suggestion on validation, but it is too short and will not do what I need comments to do.

Simon, Can you please give me an explaination as to what this code does. I've never seen anything like this. Looks interesting, but I simply don't know how even to use it.

How do I call the code since it is Private or do I simply attach it to a macro?

I can not use a macro in each cell that I have a comment

**Simon Lloyd** · 04-14-2008, 03:27 AM

press Alt+F11 double click the worksheet name on the left and paste it in, the code will only bring your comment cell to the left if the column number is greater than 11 but you can alter that, other than that there is no way to automatically view comments on the right!

**Launchnet** · 04-14-2008, 07:56 AM

Trying to follow your instructions. Please describe where I find the worksheet name on the left. The only worksheet name that I see is at the very top of the sheet on the left side, which reads: Microsoft Excel - LinkMenu. I've tried double clicking but nothing happens.

I've tried hoovering over the cell so that the comments are displayed.
I've tried selecting the cell where the comments are.

Nothing happens when I do your suggestion.

Thread: Comments Display Error

Thread Tools

Display

Comments Display Error

Sorry - Not what I need

Dave 1st. Simon 2nd

Where is the worksheet Name

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions