Comment box position

I have a workbook that makes extensive use of comment boxes.

When the comment displays, it always displays to the RIGHT of the commented cell. This causes comments in the RIGHT hand columns, and on the BOTTOM rows to extend beyond the viewable screen. The user must scroll over, or down (or sometimes both) to read the comment.

Is there any way to force the comment box to display in a different position?

Hi,

Take a look at Debra's solution ...

http://www.contextures.com/xlcomments03.html#Centre

HTH
Carim

I had already discovered the page at Contextures.com that you posted a link to....
and I copied and pasted the code into the workbook...but, it didn't work.

Is there a flaw in the code on the webpage...???

That solution is exactly what I am looking for, and I would love to make it work.

Hi,

It is working perfectly ...

But you are dealing with an event macro ...

Go to worksheet tab
right click
select view code
copy code in sheet module ...

Enjoy it ...!!!

HTH
Carim

Carim....it DOES work perfectly.

I didn't realize that you had to click on the cell.

Is there any way to modify the code so that the user only needs to put the cursor on the cell....??
And, have the comment disappear when the cell is selected??

Sorry but you do not have to click ...

it is a selectionchange event ...

Leave your mouse aside for a few seconds, and use arrows to move your cursor ...
unless you mean clicking to indicate selecting the cell ...

HTH
Carim

Yes, by clicking on the cell...I meant selecting the cell.

The comment normally appears when the cursor is placed within the cell.
The VBA code is run only after the cell is selected....and it doesn't go away until you click on a different cell.

I would like a mouse-over to initiate the code. Selecting the cell would turn OFF the comment...as would moving the cursor out of the cell.

What changes do I need to make to this code to achieve this...???

Sorry ...

I am afraid there is no MouseOver event for a cell ...

Carim