Flip comment to left
 

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

Flip comment to left
 

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

--
Regards,
Tom Ogilvy

"Jos Vens" wrote in message
...
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

Flip comment to left
 

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" schreef in bericht
...
The comment has a shape property. You can try using the Top and left
properties of the shape property.

--
Regards,
Tom Ogilvy

"Jos Vens" wrote in message
...
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

Flip comment to left
 

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

--
Regards,
Tom Ogilvy


"Jos Vens" wrote in message
...
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" schreef in bericht
...
The comment has a shape property. You can try using the Top and left
properties of the shape property.

--
Regards,
Tom Ogilvy

"Jos Vens" wrote in message
...
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