| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I flip a symbol? | Excel Discussion (Misc queries) | |||
| How can I edit a comment w/o first having to select Show Comment | Excel Discussion (Misc queries) | |||
| How can I move the comment box to the left of the cell? | Excel Worksheet Functions | |||
| a comment plugin & copy paste directly from excel to comment ? fr. | Excel Worksheet Functions | |||
| Comment to the Left | Excel Programming | |||
![Jos Vens[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
