How to change the Joint Type in Excel VBA?
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 85%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKH%3C/text%3E%3C/svg%3E)
김형규(KIM HYUNGGYU)
1
Reputation point
I draw a shape using Excel VBA. When I used Excel version 2003, shape is shown very good. But, after upgrade version, shape is not shown well. The reason of this error is from the Join Type. When I change the join type in format of shape to round, then it is shown well as like in version 2003, but default value is not round. Therefore, I want to change the Join Type using VBA, but I cannot find its property in VBA.
Please let me know how to change the Join Type in VBA.
It is impossible, then please make round type default for the Join Type. And also, please update Excel VBA and make it possible to change the Join Type in next revision.