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