Flip comment to left

[Jos Vens]

Hi,

how can I let a comment flip to the left side in stead of the default right
side. I know, excel does it automatically, but I want to do it
programmatically.

Thanks
Jos Vens

 

[Tom Ogilvy]

The comment has a shape property. You can try using the Top and left
properties of the shape property.

 

[Jos Vens]

Hi Tom,

the left property only works when my comment exceeds the right border of the
visible cells on the right. Can I force excel to flip always to the left?

Thanks
Jos Vens

 

[Tom Ogilvy]

No, if you mean to have it dynamically displayed. then not that I am aware
of.