セルの表示形式・表示位置など:Excel VBA入門 |
スポンサードリンク | |
セルの表示形式(NumberFormatLocal) | セル内の表示位置・向き |
Sub rei19_01() Range("A1:A3").Value = 1234.5 Range("A1").NumberFormatLocal = "#,###.#" Range("A2").NumberFormatLocal = "[緑]#,###.#" Range("A3").NumberFormatLocal = "[DBNum1][赤]#,###.#" End Sub |
A | B | C | D | |
1 | 商品名 | 単価 | 数量 | 金額 |
2 | ペン | \10/本 | 3 | \30 |
3 | ノート | \150/冊 | 10 | \1,500 |
H | I | |
1 | 鉛筆 | 本 |
2 | ノート | 冊 |
3 | ペン | 本 |
Private Sub Worksheet_Change(ByVal Target As Range) Dim unit Dim myVal Dim i As Long If Target.Count <> 1 Then Exit Sub If Target.Column = 2 And Target.Row > 1 Then myVal = Range("H1", Range("H" & Rows.Count).End(xlUp)).Resize(, 2).Value For i = 1 To UBound(myVal) If myVal(i, 1) = Target.Offset(, -1).Value Then unit = myVal(i, 2) Exit For End If Next i unit = "\#,##0" + """" + "/" + unit + """" Target.NumberFormatLocal = unit End If End Sub |
Sub rei19_02() Range("A1:A5").Value = "2007/2/5" Range("A1").NumberFormatLocal = "yyyy/m/d" Range("A2").NumberFormatLocal = "yyyy/mm/dd" Range("A3").NumberFormatLocal = "yyyy/mm/dd (aaa)" Range("A4").NumberFormatLocal = "ggge年m月d日" Range("A5").NumberFormatLocal = "ggge年m月d日 (aaa)" End Sub |
Sub rei19_03() Range("A1").Value = "1-1" Range("A1").NumberFormatLocal = "@" End Sub |
Sub rei19_04() Range("A2").NumberFormatLocal = "@" Range("A2").Value = "1-1" End Sub |
Sub Rei19_05() Range("A1").HorizontalAlignment = xlHAlignLeft Range("B1").HorizontalAlignment = xlHAlignCenter Range("C1").HorizontalAlignment = xlHAlignRight Range("A2").VerticalAlignment = xlVAlignTop Range("B2").VerticalAlignment = xlVAlignCenter Range("C2").VerticalAlignment = xlVAlignBottom End Sub |
xlHAlignGeneral | 標準 | 1 |
xlHAlignLeft | 左詰め | -4131 |
xlHAlignCenter | 中央 | -4108 |
xlHAlignRight | 右詰め | -4152 |
xlHAlignCenterAcrossSelection | 選択範囲内で中央 | 7 |
xlHAlignDistributed | 均等割り付け | -4117 |
xlHAlignFill | 繰り返し | 5 |
xlHAlignJustify | 両端揃え | -4130 |
xlVAlignTop | 上詰め | -4160 |
xlVAlignCenter | 中央 | -4108 |
xlVAlignBottom | 下詰め | -4107 |
xlVAlignJustify | 両端揃え | -4130 |
xlVAlignDistributed | 均等割り付け | -4117 |
Sub Rei19_06() Range("A1").Orientation = xlDownward Range("B1").Orientation = xlHorizontal Range("C1").Orientation = xlUpward Range("D1").Orientation = xlVertical End Sub |
Sub Rei19_07() Range("A2").Orientation = -90 Range("B2").Orientation = -45 Range("C2").Orientation = 0 Range("D2").Orientation = 45 Range("E2").Orientation = 90 End Sub |
xlDownward | 下向き | -4170 |
xlHorizontal(既定値) | 水平 | -4128 |
xlUpward | 上向き | -4171 |
xlVertical | 垂直 | -4166 |
Sub Rei19_08() Range("B2").WrapText = True Range("B4").ShrinkToFit = True Range("B6:C7").MergeCells = True End Sub |
スポンサードリンク
PageViewCounter
Since2006/2/27