Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add comment, and move up
I am using VBA to add a comment to a cell, fill the comment with text,
and size the comment's width and height. Unfortunately, the cell is close to the bottom of the screen, and I would like to be able to move the comment up somewhat so the entire comment can be read without having to scroll down. I can record the movement of the comment up, but that code doesn't work when I attempt to fit it into my VBA. I thought one of these might work: ActiveCell.Comment.Shape.IncrementTop -100# or ActiveCell.Comment.Shape.IncrementTop -500 When I ran it, it didn't complain, but it also didn't do anything. Does anyone have any ideas? Thanks, Carroll Rinehart |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Move Comment into cell as Text | Excel Discussion (Misc queries) | |||
Move comment into cell as text | Excel Discussion (Misc queries) | |||
What would cause the comment box to resize and move on it's own? | Excel Worksheet Functions | |||
Is there a way to move a hidden comment on a worksheet? | Excel Discussion (Misc queries) | |||
How can I move the comment box to the left of the cell? | Excel Worksheet Functions |