「EXCEL VBA 儲存格的格式設定」:修訂間差異

出自TSK WIKI
跳至導覽 跳至搜尋
Root​(留言 | 貢獻)
新頁面: EXCEL VBA:儲存格的格式設定 ================== Range("A1").Select With Selection .HorizontalAlignment = xlLeft '水平對齊 .VerticalAlignment = xlCenter '鉛直...
 
Root​(留言 | 貢獻)
第14行: 第14行:
     .MergeCells = False                    '設定合拼儲存格
     .MergeCells = False                    '設定合拼儲存格
     .Interior.ColorIndex = 9                '填滿的顏色  
     .Interior.ColorIndex = 9                '填滿的顏色  
End With
    End With
 
==================
==================
水平對齊:
水平對齊:

於 2015年8月12日 (三) 19:46 的修訂

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

===========================