|
[广告] VBA代码宝 - VBA编程加强工具 · VBA代码随查随用 · 内置多项VBA编程加强工具 ★ 免费下载 ★ ★ 使用手册★
Sub coBY001_()
‘ 从 C5 的中心向 F9 的中心 画一条射线
Dim x1 As Single, x2 As Single, y1 As Single, y2 As Single
x1 = [c5].Left + [c5].Width / 2
y1 = [c5].Top + [c5].Height / 2
x2 = [f9].Left + [f9].Width / 2
y2 = [f9].Top + [f9].Height / 2
With ActiveSheet.Shapes.AddLine(x1, y1, x2, y2).Line ’ 下面的属性决定直线的样式和外观,可以自己选择
.DashStyle = msoLineDashDotDot
.ForeColor.RGB = RGB(50, 0, 128)
.BeginArrowheadLength = msoArrowheadShort
.BeginArrowheadStyle = msoArrowheadOval
.BeginArrowheadWidth = msoArrowheadNarrow
.EndArrowheadLength = msoArrowheadLong
.EndArrowheadStyle = msoArrowheadTriangle
.EndArrowheadWidth = msoArrowheadWide
End With
End Sub
[ 本帖最后由 coby001 于 2009-11-9 10:12 编辑 ] |
|