Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming,microsoft.public.office.developer.vba
|
|||
|
|||
Corner Roundness
Is the a way in VBA to modify the roundness of a rounded rectangle?
I have a table that I am adding rows to that is surrounded by a rounded rectangle that I am dynamically resizing, but if it gets to big the rounded corners start to "cut in" to the table. |
#2
Posted to microsoft.public.excel.programming,microsoft.public.office.developer.vba
|
|||
|
|||
Corner Roundness
David,
Recording a macro whilst doing this (moving the yellow diamond above the top left corner) produces: Selection.ShapeRange.Adjustments.Item(1) = 0.0581 You'll have to determine what acceptable value are likely to be. NickHK "David Maggard" wrote in message ... Is the a way in VBA to modify the roundness of a rounded rectangle? I have a table that I am adding rows to that is surrounded by a rounded rectangle that I am dynamically resizing, but if it gets to big the rounded corners start to "cut in" to the table. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
round corner background | Excel Discussion (Misc queries) | |||
Printing Comments- just the corner | Excel Discussion (Misc queries) | |||
missing X in the top right corner | Excel Discussion (Misc queries) | |||
insert 2 colours in a single cell,corner to corner | Excel Worksheet Functions | |||
How to get to lower right corner | Excel Discussion (Misc queries) |