Changing comment position ?

[Billm]

Is it possible to change the position of the red triangle in a cell that denotes a comment ?

My worksheet is restricted to only a couple of columns and the comment in the last column displays outside of the users viewable area. Is there some way of making the comment display to the Left of the cell as opposed to the right as standard ?

Thanks
Bill

 

[Jack in the UK]

i could go off you Chris!

dam times you snarl, did you try my camra trick, nope i grumply say,

again your right!

i should really learn, frightening thing is i just know this will work arround just fine....

a very big BIG thanks Chris... a quality fix!

 

[Chris Davison]

I'd noticed that too... are your fingers healing now Jack ?

 

[Chris Davison]

cheers.... it's really a last resort though, it has some serious drawbacks.

Pretty nifty though, comments popping up both left and right !

 

[Jack in the UK]

fingers are broken not the bone the tipof the bone so bit floats about and other messy twisted, to many times i guess.

Dr warned me no more impacts or my hand cpuld colaps.. should see the xray, every joint is damaged, to may heads i have hit i guess.

but they stil hurt and anoy me, but ive tested them in case of troubles in my streets and im fine, just have to not mess about - just keep it business.

Funny people are generally nice and polite tome when im out, cant think why im super polite as you expect...

pop up both side well i fancy it what you do is have the all over the place i guess.

you idea the camra and i feel some heavy exploting needed of this gadget, ido not feel it have been exchausted but a long way

cheers chris, also i won 2 1 sunday, you know my team never looses regardless of what side im on!

 

[mdali]

If your excel comments have moved out of position, you can reset them to there original position by using the following code:

Sub ResetComments()
Dim cmt As Comment
For Each cmt In ActiveSheet.Comments
cmt.Shape.Top = cmt.Parent.Top + 5
cmt.Shape.Left = _
cmt.Parent.Offset(0, 1).Left + 5
Next
End Sub

Regards,
Mohammed Ali
http://daily-exceltips.blogspot.com/​

 

[Excelestial]

Have you tried DATA VALIDATION...where you can include a comment that will appear when the user hovers the pointer over its area?

 

[Jaafar Tribak]

I posted some code HERE that dinamically changes the position of comments to the left when pointing the mouse over the cell .

It uses a background loop which kind of has a performance hit.

If anyone is further interested in this , I can adapt the code so the loop runs in an out of process VBS file and doesn't affect the workbook performance.

Regards.