EXCEL VBA 儲存格的格式設定
跳至導覽
跳至搜尋
EXCEL VBA:儲存格的格式設定
======
Range("A1").Select With Selection
.HorizontalAlignment = xlLeft '水平對齊
.VerticalAlignment = xlCenter '鉛直對齊
.WrapText = False '設定自動換列
.Orientation = 0 '設定方向的角度
.AddIndent = False '設定縮排
.IndentLevel = 0 '設定縮排的值
.ShrinkToFit = False '設定縮小字形以適合欄寬
'設定文字方向,xlContext內容,xlLTR從左至右,xlRTL從右至左
.ReadingOrder = xlContext '設定文字方向
.MergeCells = False '設定合拼儲存格
.Interior.ColorIndex = 9 '填滿的顏色
End With
======
水平對齊: .HorizontalAlignment 的設定值:
xlGeneral 通用格式 xlLeft 靠左 xlCenter中間對齊 xlRight靠右 xlFill 填滿 xlJustify 段落重排 xlCenterAcrossSelection 跨欄置中 xlDistributed 分散對齊 ( 縮排 )
鉛直對齊: .VerticalAlignment的設定值:
xlTop 靠上 xlCenter 置中對齊 xlBottom 靠下 xlJustify段落重排 xlDistributed分散對齊
=====================================
'自動調整行高列寬 Columns("A:A").EntireColumn.AutoFit Rows("1:1").EntireRow.AutoFit
===================================== '儲存格的資料格式: Selection.NumberFormatLocal = "G/通用格式" Selection.NumberFormatLocal = "0.00_ " Selection.NumberFormatLocal = "$#,##0.00" Selection.NumberFormatLocal = "_-$* #,##0.00_-;-$* #,##0.00_-;_-$* ""-""??_-;_-@_-" Selection.NumberFormatLocal = "yyyy/m/d" Selection.NumberFormatLocal = "[$-F400]h:mm:ss AM/PM" Selection.NumberFormatLocal = "0.00%" Selection.NumberFormatLocal = "# ?/?" Selection.NumberFormatLocal = "0.00E+00" Selection.NumberFormatLocal = "@" Selection.NumberFormatLocal = "000"
=====================================
Selection.Font.Name = "新細明體"
Range("A1").Font.Name = "標楷體"
MsgBox Range("A1").Font.Name
Selection.Font.ColorIndex = '設定字體的顏色
Selection.Font.Size = '設定字體的大小
=====================================
Range("A1").Select
With Selection.Font
.Name = "新細明體"
.Size = "20"
.Bold = True
.Italic = True
.Underline = True
End With