|
|
|
|
|
|
|
|
■色 |
|
|
|
vbBlack |
0x0 |
黒 |
|
|
|
|
|
|
|
|
|
vbRed |
0xFF |
赤 |
|
|
|
|
|
|
|
|
|
vbGreen |
0xFF00 |
緑 |
|
|
|
|
|
|
|
|
|
vbYellow |
0xFFFF |
黄 |
|
|
|
|
|
|
|
|
|
vbBlue |
0xFF0000 |
青 |
|
|
|
|
|
|
|
|
|
vbMagenta |
0xFF00FF |
マゼンタ |
|
|
|
|
|
|
|
|
|
vbCyan |
0xFFFF00 |
シアン |
|
|
|
|
|
|
|
|
|
vbWhite |
0xFFFFFF |
白 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
■キャラクターコード |
|
|
|
vbCrLf |
Chr(13) + Chr(10) |
キャリッジ リターン+ライン フィード |
|
|
|
|
|
|
|
|
|
vbCr |
Chr(13) |
キャリッジ リターン |
|
|
|
|
|
|
|
|
|
vbLf |
Chr(10) |
ライン フィード |
|
|
|
|
|
|
|
|
|
vbNullChar |
Chr(0) |
値 0 を持つ文字 |
|
|
|
|
|
|
|
|
|
vbNewLine |
Chr(13) + Chr(10) または Chr(13) |
改行文字 |
|
|
|
|
|
|
|
|
|
vbNullString |
値 0 を持つ文字列 |
外部プロシージャを呼び出す場合に使用 |
|
|
|
|
|
|
|
|
|
vbTab |
Chr(8) |
タブ文字 |
|
|
|
|
|
|
|
|
|
vbBack |
Chr(8) |
バックスペース文字 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
■表示位置 横方向 |
|
|
|
xlHAlignCenter |
中央揃え |
|
|
|
|
|
|
|
|
|
|
xlHAlignDistributed |
均等割り付け |
|
|
|
|
|
|
|
|
|
|
xlHAlignJustify |
両端揃え |
|
|
|
|
|
|
|
|
|
|
xlHAlignLeft |
左詰め |
|
|
|
|
|
|
|
|
|
|
xlHAlignRight |
右詰め |
|
|
|
|
|
|
|
|
|
|
xlHAlignCenterAcrossSelection |
選択範囲内で中央 |
|
|
|
|
|
|
|
|
|
|
xlHAlignFill |
繰り返し |
|
|
|
|
|
|
|
|
|
|
xlHAlignGeneral |
標準 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
■表示位置 縦方向 |
|
|
|
xlVAlignBottom |
下詰め |
|
|
|
|
|
|
|
|
|
|
xlVAlignCenter |
中央揃え |
|
|
|
|
|
|
|
|
|
|
xlVAlignDistributed |
均等割り付け |
|
|
|
|
|
|
|
|
|
|
|
|
xlVAlignJustify |
両端揃え |
|
|
|
|
|
|
|
|
|
|
xlVAlignTop |
上詰め |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
■IMEStatus 関数の定数
|
|
|
|
vbIMEModeNoControl |
0 |
IME を制御しない(既定値) |
|
|
|
|
|
|
|
|
|
vbIMEModeOn |
1 |
IME はオンの状態 |
|
|
|
|
|
|
|
|
|
vbIMEModeOff |
2 |
IME はオフの状態 |
|
|
|
|
|
|
|
|
|
vbIMEModeDisable |
3 |
IME は利用禁止状態 |
|
|
|
|
|
|
|
|
|
vbIMEModeHiragana |
4 |
IME は全角ひらがな入力モード |
|
|
|
|
|
|
|
|
|
vbIMEModeKatakana |
5 |
IME は全角カタカナ入力モード |
|
|
|
|
|
|
|
|
|
vbIMEModeKatakanaHalf |
6 |
IME は半角カタカナ入力モード |
|
|
|
|
|
|
|
|
|
vbIMEModeAlphaFull |
7 |
IME は全角英数入力モード |
|
|
|
|
|
|
|
|
|
vbIMEModeAlpha |
8 |
IME は半角英数入力モード |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
■罫線を引くときの定数（XlBordersIndex クラス） |
|
|
|
xlEdgeLeft |
7 |
選択範囲の最左端 |
|
|
|
|
|
|
|
|
|
|
|
xlEdgeRight |
10 |
選択範囲の最右端 |
|
|
|
|
|
|
|
|
|
|
|
|
|
xlEdgeTop |
8 |
選択範囲の最上端 |
|
|
|
|
|
|
|
|
|
|
|
|
|
xlEdgeBottom |
9 |
選択範囲の最下端 |
|
|
|
|
|
|
|
|
|
|
|
|
|
xlInsideHorizontal |
12 |
選択範囲の上下端以外の境界線 |
|
|
|
|
|
|
|
|
|
|
|
|
|
xlInsideVertical |
11 |
選択範囲の左右端以外の境界線 |
|
|
|
|
|
|
|
|
|
|
|
|
|
xlDiagonalUp |
6 |
個々のセルの右上がり斜線 |
|
|
|
|
|
|
|
|
|
|
|
|
|
xlDiagonalDown |
5 |
個々のセルの右下がり斜線 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
■線種 |
|
|
|
|
|
xlContinuous |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
xlDash |
-4115 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
xlDashDot |
4 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
xlDashDotDot |
5 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
xlDot |
-4118 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
xlDouble |
-4119 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
xlLineStyleNone |
-4142 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
xlSlantDashDot |
13 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
■線の太さ |
|
|
|
|
|
xlHairline |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
xlMedium |
-4138 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
xlThick |
4 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
xlThin |
2 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|