|
‘’‘’‘ "如何用VBA宏将EXCEL 2007文本框里面的文字(段落)设成分散对齐"
’‘’‘’‘’‘'以下代码将 xlHAlignDistributed 改为 xlRight ' xlCenter ' 右对齐、居中均有效,但分散对齐则无效,求高手赐教!
Sub 设置文本框分散对齐()
With Sheets(1).Shapes.AddShape(msoTextOrientationHorizontal, 180, 80, 360, 60)
.TextFrame.HorizontalAlignment = xlHAlignDistributed 'xlRight ' xlCenter ' 右对齐、居中均有效,但分散对齐则无效,求高手赐教!
With .TextFrame2.TextRange
.Font.Size = 18
.Font.Name = "黑体"
.Font.NameFarEast = "黑体"
.Text = "如何用VBA宏将EXCEL 2007文本框里面的文字(段落)设成分散对齐"
End With
End With
End Sub
- With ActiveSheet.Shapes(1)
- With .TextFrame2.TextRange
- With .Characters.ParagraphFormat
- .Alignment = msoAlignDistribute
- End With
- End With
- End With
复制代码
|
|