[求助]哪位达人用过spreadsheet?如何用代码加边框,如何自动换行?
如题所示:With Selection.Borders(xlEdgeRight) '右边框
.LineStyle = xlContinuous
.Weight = xlThin
.ColorIndex = xlAutomatic
End With
With Selection
.HorizontalAlignment = xlGeneral
.VerticalAlignment = xlCenter
.wraptext = True '自动换行
.Orientation = 0
.AddIndent = False
.IndentLevel = 0
.ShrinkToFit = False
.ReadingOrder = xlContext
.MergeCells = False
End With
以上这两个怎么不能用?
还有就是如何在按回车键后,让他从指定单元格跳转到另一指定单元格?
如何能让单元格获得焦点?setfocus 怎么不能用?
[此贴子已经被作者于2007-8-19 9:24:48编辑过]