Excel VBAのConstants列挙型には、たくさんの定数が定義されています。
たくさん存在する定数を、値順に眺めたかったので値の昇順で並べた一覧を作成しておきます。
もちろん、ヘルプやオブジェクトブラウザーを使って、アルファベット順ならば確認できます。
［スポンサードリンク］
| 定数 | 値 |
|---|---|
| xlRTL | -5004 |
| xlLTR | -5003 |
| xlContext | -5002 |
| xlLatin | -5001 |
| xlBidi | -5000 |
| xlTop | -4160 |
| xlSimple | -4154 |
| xlRight | -4152 |
| xlOff | -4146 |
| xlNotes | -4144 |
| xlNone | -4142 |
| xlModule | -4141 |
| xlManual | -4135 |
| xlLow | -4134 |
| xlLeft | -4131 |
| xlJustify | -4130 |
| xlHigh | -4127 |
| xlGray75 | -4126 |
| xlGray50 | -4125 |
| xlGray25 | -4124 |
| xlFormats | -4122 |
| xlDistributed | -4117 |
| xlCustom | -4114 |
| xlCombination | -4111 |
| xlCenter | -4108 |
| xlBottom | -4107 |
| xlAutomatic | -4105 |
| xlAll | -4104 |
| xl3DSurface | -4103 |
| xl3DBar | -4099 |
| xlDefaultAutoFormat | -1 |
| xlAbove | 0 |
| xlFirst | 0 |
| xlBelow | 1 |
| xlBoth | 1 |
| xlClassic1 | 1 |
| xlDirect | 1 |
| xlDoubleQuote | 1 |
| xlExcelMenus | 1 |
| xlFixedValue | 1 |
| xlFullScript | 1 |
| xlGeneral | 1 |
| xlIcons | 1 |
| xlLast | 1 |
| xlLogicalCursor | 1 |
| xlNarrow | 1 |
| xlOn | 1 |
| xlShort | 1 |
| xlSolid | 1 |
| xlSquare | 1 |
| xlSystem | 1 |
| xlTiled | 1 |
| xlToolbar | 1 |
| xlTopToBottom | 1 |
| xlWorksheet4 | 1 |
| xlAdd | 2 |
| xlBar | 2 |
| xlChart4 | 2 |
| xlClassic2 | 2 |
| xlConstants | 2 |
| xlContents | 2 |
| xlCorner | 2 |
| xlDiamond | 2 |
| xlGregorian | 2 |
| xlInside | 2 |
| xlInteger | 2 |
| xlLeftToRight | 2 |
| xlLotusHelp | 2 |
| xlMaximum | 2 |
| xlMixed | 2 |
| xlOpen | 2 |
| xlPartialScript | 2 |
| xlPercent | 2 |
| xlPlusValues | 2 |
| xlSemiautomatic | 2 |
| xlShowValue | 2 |
| xlSingle | 2 |
| xlSingleQuote | 2 |
| xlStrict | 2 |
| xlToolbarButton | 2 |
| xlTransparent | 2 |
| xlVeryHidden | 2 |
| xlVisualCursor | 2 |
| xlNoDocuments | 3 |
| xlBidiCalendar | 3 |
| xlClassic3 | 3 |
| xlClosed | 3 |
| xlColumn | 3 |
| xlExtended | 3 |
| xlHindiNumerals | 3 |
| xlLong | 3 |
| xlMinusValues | 3 |
| xlMixedScript | 3 |
| xlOpaque | 3 |
| xlOutside | 3 |
| xlPartial | 3 |
| xlScale | 3 |
| xlShowPercent | 3 |
| xlSubtract | 3 |
| xlTriangle | 3 |
| xlWide | 3 |
| xlWorksheetCell | 3 |
| xlNextToAxis | 4 |
| xlAccounting1 | 4 |
| xlComplete | 4 |
| xlCross | 4 |
| xlDoubleOpen | 4 |
| xlMinimum | 4 |
| xlMixedAuthorizedScript | 4 |
| xlMultiply | 4 |
| xlReference | 4 |
| xlShowLabel | 4 |
| xlSingleAccounting | 4 |
| xlStError | 4 |
| xlAccounting2 | 5 |
| xlDivide | 5 |
| xlDoubleAccounting | 5 |
| xlDoubleClosed | 5 |
| xlFill | 5 |
| xlFloating | 5 |
| xlFormula | 5 |
| xlShowLabelAndPercent | 5 |
| xlStar | 5 |
| xlWorksheetShort | 5 |
| xlAccounting3 | 6 |
| xlChartShort | 6 |
| xlWorkbookTab | 6 |
| xlAllExceptBorders | 7 |
| xlCascade | 7 |
| xlCenterAcrossSelection | 7 |
| xlColor1 | 7 |
| xlMacrosheetCell | 7 |
| xlCircle | 8 |
| xlColor2 | 8 |
| xlTitleBar | 8 |
| xlChecker | 9 |
| xlColor3 | 9 |
| xlDesktop | 9 |
| xlPlus | 9 |
| xlList1 | 10 |
| xlSemiGray75 | 10 |
| xlLastCell | 11 |
| xlLightHorizontal | 11 |
| xlList2 | 11 |
| xlWatchPane | 11 |
| xlImmediatePane | 12 |
| xlLightVertical | 12 |
| xlList3 | 12 |
| xlVisible | 12 |
| xl3DEffects1 | 13 |
| xlDebugCodePane | 13 |
| xlLightDown | 13 |
| xl3DEffects2 | 14 |
| xlDrawingObject | 14 |
| xlLightUp | 14 |
| xlGrid | 15 |
| xlLocalFormat1 | 15 |
| xlCrissCross | 16 |
| xlLocalFormat2 | 16 |
| xlTextBox | 16 |
| xlAccounting4 | 17 |
| xlChartSeries | 17 |
| xlGray16 | 17 |
| xlChartTitles | 18 |
| xlGray8 | 18 |
| xlEntireChart | 20 |
| xlGridline | 22 |
最終更新日時：2023-06-26 13:34
［スポンサードリンク］
Home » エクセルマクロ・Excel VBAの使い方 » ExcelのConstants列挙型に定義されている定数一覧
