Constantes, énumération (Excel)
Cette énumération regroupe les constantes utilisées avec les diverses méthodes d’Excel.
| Nom | Valeur | Description |
|---|---|---|
| xl3DBar | -4099 | 3D Bar |
| xl3DEffects1 | 13 | Effets 3D1 |
| xl3DEffects2 | 14 | Effets 3D2 |
| xl3DSurface | -4103 | 3D Surface |
| xlAbove | 0 | Ci-dessus |
| xlAccounting1 | 4 | Comptabilité1 |
| xlAccounting2 | 5 | Comptabilité2 |
| xlAccounting4 | 17 | Comptabilité4 |
| xlAjouter | 2 | Ajouter |
| xlAll | -4104 | tous |
| xlAccounting3 | 6 | Comptabilité3 |
| xlAllExceptBorders | 7 | All Except Borders |
| xlAutomatic | -4105 | Automatique |
| xlBar | 2 | Automatique |
| xlBelow | 1 | En dessous |
| xlBidi | -5000 | Bidi |
| xlBidiCalendar | 3 | BidiCalendar |
| xlBoth | 1 | Les deux |
| xlBottom | -4107 | Inférieure |
| xlCascade | 7 | Cascade |
| xlCenter | -4108 | Centre |
| xlCenterAcrossSelection | 7 | Center Across Selection |
| xlChart4 | 2 | Chart 4 |
| xlChartSeries | 17 | Chart Series |
| xlChartShort | 6 | Chart Short |
| xlChartTitles | 18 | Chart Titles |
| xlChecker | 9 | Checker |
| xlCircle | 8 | Cercle |
| xlClassic1 | 1 | Classique1 |
| xlClassic2 | 2 | Classique2 |
| xlClassic3 | 3 | Classique3 |
| xlClosed | 3 | Fermé |
| xlColor1 | 7 | Couleur1 |
| xlColor2 | 8 | Color2 |
| xlColor3 | 9 | Couleur3 |
| xlColumn | 3 | Column |
| xlCombination | -4111 | Combinaison |
| xlComplete | 4 | Exécuter |
| xlConstants | 2 | Constantes |
| xlContents | 2 | Sommaire |
| xlContext | -5002 | Contexte |
| xlCorner | 2 | Coin |
| xlCrissCross | 16 | Entrecroisent |
| xlCross | 4 | Cross |
| xlCustom | -4114 | Personnalisé |
| xlDebugCodePane | 13 | Debug Code Pane |
| xlDefaultAutoFormat | -1 | Default Auto Format |
| xlDesktop | 9 | Ordinateur de bureau |
| xlDiamond | 2 | Diamant |
| xlDirect | 1 | Direct |
| xlDistributed | -4117 | Distribué |
| xlDivide | 5 | Diviser |
| xlDoubleAccounting | 5 | Double Accounting |
| xlDoubleClosed | 5 | Double Closed |
| xlDoubleOpen | 4 | Double Open |
| xlDoubleQuote | 1 | Double Quote |
| xlDrawingObject | 14 | Drawing Object |
| xlEntireChart | 20 | Entire Chart |
| xlExcelMenus | 1 | Excel Menus |
| xlExtended | 3 | Étendue |
| xlFill | 5 | Remplissage |
| xlFirst | 0 | Premier |
| xlFixedValue | 1 | Fixed Value |
| xlFloating | 5 | Flottant |
| xlFormats | -4122 | Formats |
| xlFormula | 5 | Formule |
| xlFullScript | 1 | Full Script |
| xlGénéral | 1 | Généralités |
| xlGray16 | 17 | Gris16 |
| xlGray25 | -4124 | Gris25 |
| xlGray50 | -4125 | Gris50 |
| xlGray75 | -4126 | Gris75 |
| xlGray8 | 18 | Gris8 |
| xlGregorian | 2 | Grégorien |
| xlGrid | 15 | Grille |
| xlGridline | 22 | Quadrillage |
| xlHigh | -4127 | Élevé |
| xlHindiNumerals | 3 | Hindi Numerals |
| xlIcons | 1 | Icônes |
| xlImmediatePane | 12 | Immediate Pane |
| xlInside | 2 | Inside |
| xlInteger | 2 | Entier |
| xlJustify | -4130 | Justifier |
| xlLast | 1 | Nom |
| xlLastCell | 11 | Last Cell |
| xlLatin | -5001 | Latin |
| xlLeft | -4131 | Gauche |
| xlLeftToRight | 2 | Left To Right |
| xlLightDown | 13 | Light Down |
| xlLightHorizontal | 11 | Light Horizontal |
| xlLightUp | 14 | Light Up |
| xlLightVertical | 12 | Light Vertical |
| xlList1 | 10 | Liste1 |
| xlList2 | 11 | Liste2 |
| xlList3 | 12 | Liste3 |
| xlLocalFormat1 | 15 | Local Format1 |
| xlLocalFormat2 | 16 | Local Format2 |
| xlLogicalCursor | 1 | Logical Cursor |
| xlLong | 3 | Entier long |
| xlLotusHelp | 2 | Lotus Help |
| xlLow | -4134 | Faible |
| xlLTR | -5003 | LTR |
| xlMacrosheetCell | 7 | MacrosheetCell |
| xlManual | -4135 | Manual |
| xlMaximum | 2 | Maximum |
| xlMinimum | 4 | Minimum |
| xlMinusValues | 3 | Minus Values |
| xlMixed | 2 | Mixte |
| xlMixedAuthorizedScript | 4 | Mixed Authorized Script |
| xlMixedScript | 3 | Mixed Script |
| xlModule | -4141 | Module |
| xlMultiply | 4 | Multiplier |
| xlNarrow | 1 | Étroite |
| xlNextToAxis | 4 | Next To Axis |
| xlNoDocuments | 3 | No Documents |
| xlNone | -4142 | Aucun |
| xlNotes | -4144 | Notes |
| xlOff | -4146 | Désactivé |
| xlOn | 1 | Activé |
| xlOpaque | 3 | Opaque |
| xlOpen | 2 | Ouvrir |
| xlOutside | 3 | Extérieur |
| xlPartial | 3 | Partiel |
| xlPartialScript | 2 | Partial Script |
| xlPercent | 2 | Pourcentage |
| xlPlus | 9 | Plus |
| xlPlusValues | 2 | Plus Values |
| xlReference | 4 | Référence |
| xlRight | -4152 | Droite |
| xlRTL | -5004 | RTL |
| xlScale | 3 | Échelle |
| xlSemiautomatic | 2 | Semi-automatique |
| xlSemiGray75 | 10 | SemiGray75 |
| xlShort | 1 | Nom court |
| xlShowLabel | 4 | Show Label |
| xlShowLabelAndPercent | 5 | Show Label and Percent |
| xlShowPercent | 3 | Show Percent |
| xlShowValue | 2 | Show Value |
| xlSimple | -4154 | Simple |
| xlSingle | 2 | Unique |
| xlSingleAccounting | 4 | Single Accounting |
| xlSingleQuote | 2 | Single Quote |
| xlSolid | 1 | Uni |
| xlSquare | 1 | Square |
| xlStar | 5 | Étoile |
| xlStError | 4 | St Error |
| xlStrict | 2 | Strict |
| xlSubtract | 3 | Soustraire |
| xlSystem | 1 | Système |
| xlTextBox | 16 | Text Box |
| xlTiled | 1 | Carrelée |
| xlTitleBar | 8 | Title Bar |
| xlToolbar | 1 | Barre d'outils |
| xlToolbarButton | 2 | Toolbar Button |
| xlTop | -4160 | Haut |
| xlTopToBottom | 1 | Top To Bottom |
| xlTransparent | 2 | Transparent |
| xlTriangle | 3 | Triangle |
| xlVeryHidden | 2 | Very Hidden |
| xlVisible | 12 | Visible |
| xlVisualCursor | 2 | Visual Cursor |
| xlWatchPane | 11 | Watch Pane |
| xlWide | 3 | Large |
| xlWorkbookTab | 6 | Workbook Tab |
| xlWorksheet4 | 1 | Feuille de calcul4 |
| xlWorksheetCell | 3 | Worksheet Cell |
| xlWorksheetShort | 5 | Worksheet Short |
Assistance et commentaires
Avez-vous des questions ou des commentaires sur Office VBA ou sur cette documentation ? Consultez la rubrique concernant l’assistance pour Office VBA et l’envoi de commentaires afin d’obtenir des instructions pour recevoir une assistance et envoyer vos commentaires.