您所在的位置： 程序员家园 -> 家园博客 ->
 
在哪里摔倒
就在哪里自己爬起来

用户登录

查　　找

最新评论

最新留言

常用网站

网易邮箱 GMAIL  

百度搜索 ＭＳＤＮ

霏凡软件 ＢＴ精品

影视帝国 射 手 网

电驴下载 全 库 网

友情连接

茄菲的窝 冰冰博客

枫叶飘零 玫　　瑰

ＡＣＥＮ 云 豹 子

统　　计


※ Excel常用枚举常量列表，对应的数字终于全成查了
狼子 发表于 2005-11-6 15:52:00 阅读全文 | 回复(35) | 引用通告 | 编辑

Microsoft Excel Constants [Excel 2003 VBA Language Reference]

This topic lists all constants in the Microsoft Excel object model.

XlApplicationInternational

XlApplyNamesOrder

XlArabicModes

XlArrangeStyle

XlArrowHeadLength

XlArrowHeadStyle

XlArrowHeadWidth

XlAutoFillType

XlAutoFilterOperator

XlAxisCrosses

XlAxisGroup

XlAxisType

XlBackground

XlBarShape

XlBordersIndex

XlBorderWeight

XlBuiltInDialog

XlCalculatedMemberType

XlCalculation

XlCalculationInterruptKey

XlCalculationState

XlCategoryType

XlCellInsertionMode

XlCellType

XlChartGallery

XlChartItem

XlChartLocation

XlChartPicturePlacement

XlChartPictureType

XlChartSplitType

XlChartType

XlClipboardFormat

XlCmdType

XlColorIndex

XlColumnDataType

XlCommandUnderlines

XlCommentDisplayMode

XlConsolidationFunction

XlCopyPictureFormat

XlCorruptLoad

XlCreator

XlCubeFieldType

XlCutCopyMode

XlCVError

XlDataLabelPosition

XlDataLabelSeparator

XlDataLabelsType

XlDataSeriesDate

XlDataSeriesType

XlDeleteShiftDirection

XlDirection

XlDisplayBlanksAs

XlDisplayDrawingObjects

XlDisplayUnit

XlDVAlertStyle

XlDVType

XlEditionFormat

XlEditionOptionsOption

XlEditionType

XlEnableCancelKey

XlEnableSelection

XlEndStyleCap

XlErrorBarDirection

XlErrorBarInclude

XlErrorBarType

XlErrorChecks

XlFileFormat

※ Re:Excel常用枚举常量列表，对应的数字终于全成查了
mountain315发表评论于2005-11-6 15:58:00 个人主页 | 引用 | 返回 | 删除 | 回复

XlFillWith

XlFilterAction

XlFindLookIn

XlFormatConditionOperator

XlFormatConditionType

XlFormControl

XlFormulaLabel

※ Re:Excel常用枚举常量列表，对应的数字终于全成查了
mountain315发表评论于2005-11-6 15:58:00 个人主页 | 引用 | 返回 | 删除 | 回复

XlHAlign

XlHebrewModes

XlHighlightChangesTime

XlHtmlType

XlIMEMode

XlImportDataAs

XlInsertFormatOrigin

XlInsertShiftDirection

XlLayoutFormType

XlLegendPosition

※ Re:Excel常用枚举常量列表，对应的数字终于全成查了
mountain315发表评论于2005-11-6 15:58:00 个人主页 | 引用 | 返回 | 删除 | 回复

XlLineStyle

XlLink

XlLinkInfo

XlLinkInfoType

XlLinkStatus

XlLinkType

XlListConflict

XlListDataType

XlListObjectSourceType

※ Re:Excel常用枚举常量列表，对应的数字终于全成查了
mountain315发表评论于2005-11-6 15:59:00 个人主页 | 引用 | 返回 | 删除 | 回复

XlLocationInTable

XlLookAt

XlMailSystem

XlMarkerStyle

XlMouseButton

XlMousePointer

※ Re:Excel常用枚举常量列表，对应的数字终于全成查了
mountain315发表评论于2005-11-6 15:59:00 个人主页 | 引用 | 返回 | 删除 | 回复

XlMSApplication

XlObjectSize

XlOLEType

XlOLEVerb

XlOrder

XlOrientation

XlPageBreak

XlPageBreakExtent

XlPageOrientation

※ Re:Excel常用枚举常量列表，对应的数字终于全成查了
mountain315发表评论于2005-11-6 15:59:00 个人主页 | 引用 | 返回 | 删除 | 回复

XlPaperSize

※ Re:Excel常用枚举常量列表，对应的数字终于全成查了
mountain315发表评论于2005-11-6 15:59:00 个人主页 | 引用 | 返回 | 删除 | 回复

XlParameterDataType

XlParameterType

XlPasteSpecialOperation

※ Re:Excel常用枚举常量列表，对应的数字终于全成查了
mountain315发表评论于2005-11-6 16:00:00 个人主页 | 引用 | 返回 | 删除 | 回复

XlPasteType

XlPattern

※ Re:Excel常用枚举常量列表，对应的数字终于全成查了
mountain315发表评论于2005-11-6 16:00:00 个人主页 | 引用 | 返回 | 删除 | 回复

XlPhoneticAlignment

XlPhoneticCharacterType

XlPictureAppearance

XlPictureConvertorType

XlPivotCellType

※ Re:Excel常用枚举常量列表，对应的数字终于全成查了
mountain315发表评论于2005-11-6 16:00:00 个人主页 | 引用 | 返回 | 删除 | 回复

XlPivotFieldCalculation

XlPivotFieldDataType

XlPivotFieldOrientation

XlPivotFormatType

XlPivotTableMissingItems

XlPivotTableSourceType

※ Re:Excel常用枚举常量列表，对应的数字终于全成查了
mountain315发表评论于2005-11-6 16:00:00 个人主页 | 引用 | 返回 | 删除 | 回复

XlPivotTableVersionList

XlPlacement

XlPlatform

XlPrintErrors

XlPrintLocation

XlPriority

XlPTSelectionMode

XlQueryType

※ Re:Excel常用枚举常量列表，对应的数字终于全成查了
mountain315发表评论于2005-11-6 16:00:00 个人主页 | 引用 | 返回 | 删除 | 回复

XlRangeAutoFormat

XlRangeValueDataType

※ Re:Excel常用枚举常量列表，对应的数字终于全成查了
mountain315发表评论于2005-11-6 16:01:00 个人主页 | 引用 | 返回 | 删除 | 回复

XlReferenceStyle

XlReferenceType

XlRobustConnect

XlRoutingSlipDelivery

XlRoutingSlipStatus

XlRowCol

XlRunAutoMacro

XlSaveAction

XlSaveAsAccessMode

XlSaveConflictResolution

XlScaleType

※ Re:Excel常用枚举常量列表，对应的数字终于全成查了
mountain315发表评论于2005-11-6 16:01:00 个人主页 | 引用 | 返回 | 删除 | 回复

XlSearchDirection

XlSearchOrder

XlSearchWithin

XlSheetType

XlSheetVisibility

XlSizeRepresents

XlSmartTagControlType

※ Re:Excel常用枚举常量列表，对应的数字终于全成查了
mountain315发表评论于2005-11-6 16:01:00 个人主页 | 引用 | 返回 | 删除 | 回复

XlSmartTagDisplayMode

XlSortDataOption

XlSortMethod

XlSortMethodOld

XlSortOrder

XlSortOrientation

XlSortType

XlSourceType

XlSpeakDirection

XlSpecialCellsValue

XlSubscribeToFormat

XlSubtototalLocationType

※ Re:Excel常用枚举常量列表，对应的数字终于全成查了
mountain315发表评论于2005-11-6 16:02:00 个人主页 | 引用 | 返回 | 删除 | 回复

XlSummaryColumn

XlSummaryReportType

XlSummaryRow

XlTabPosition

XlTextParsingType

XlTextQualifier

XlTextVisualLayoutType

XlTickLabelOrientation

XlTickLabelPosition

XlTickMark

XlTimeUnit

XlToolbarProtection

※ Re:Excel常用枚举常量列表，对应的数字终于全成查了
mountain315发表评论于2005-11-6 16:02:00 个人主页 | 引用 | 返回 | 删除 | 回复

XlTotalsCalculation

XlTrendlineType

XlUnderlineStyle

XlUpdateLinks

XlVAlign

※ Re:Excel常用枚举常量列表，对应的数字终于全成查了
mountain315发表评论于2005-11-6 16:02:00 个人主页 | 引用 | 返回 | 删除 | 回复

XlWBATemplate

XlWebFormatting

XlWebSelectionType

XlWindowState

XlWindowType

XlWindowView

XlXLMMacroType

XlXmlExportResult

XlXmlImportResult

XlXmlLoadOption

※ Re:Excel常用枚举常量列表，对应的数字终于全成查了
mountain315发表评论于2005-11-6 16:07:00 个人主页 | 引用 | 返回 | 删除 | 回复

XlYesNoGuess

※ Re:Excel常用枚举常量列表，对应的数字终于全成查了
mountain315发表评论于2006-3-25 18:33:00 个人主页 | 引用 | 返回 | 删除 | 回复
{ XlSheetType }
xlChart = -4109;
xlDialogSheet = -4116;
xlExcel4IntlMacroSheet = 4;
xlExcel4MacroSheet = 3;
xlWorksheet = -4167;

{ XlWBATemplate }
xlWBATChart = -4109;
xlWBATExcel4IntlMacroSheet = 4;
xlWBATExcel4MacroSheet = 3;
xlWBATWorksheet = -4167;

{ XlPattern }
xlPatternAutomatic = -4105;
xlPatternChecker = 9;
xlPatternCrissCross = 16;
xlPatternDown = -4121;
xlPatternGray16 = 17;
xlPatternGray25 = -4124;
xlPatternGray50 = -4125;
xlPatternGray75 = -4126;
xlPatternGray8 = 18;
xlPatternGrid = 15;
xlPatternHorizontal = -4128;
xlPatternLightDown = 13;
xlPatternLightHorizontal = 11;
xlPatternLightUp = 14;
xlPatternLightVertical = 12;
xlPatternNone = -4142;
xlPatternSemiGray75 = 10;
xlPatternSolid = 1;
xlPatternUp = -4162;
xlPatternVertical = -4166;
{ XlBordersIndex }
xlInsideHorizontal = 12;
xlInsideVertical = 11;
xlDiagonalDown = 5;
xlDiagonalUp = 6;
xlEdgeBottom = 9;
xlEdgeLeft = 7;
xlEdgeRight = 10;
xlEdgeTop = 8;
※ Re:Excel常用枚举常量列表，对应的数字终于全成查了
mountain315发表评论于2006-3-25 18:33:00 个人主页 | 引用 | 返回 | 删除 | 回复
{ XlLineStyle }
xlContinuous = 1;
xlDash = -4115;
xlDashDot = 4;
xlDashDotDot = 5;
xlDot = -4118;
xlDouble = -4119;
xlSlantDashDot = 13;
xlLineStyleNone = -4142;
{ XlChartType }
xlColumnClustered = 51;
xlColumnStacked = 52;
xlColumnStacked100 = 53;
xl3DColumnClustered = 54;
xl3DColumnStacked = 55;
xl3DColumnStacked100 = 56;
xlBarClustered = 57;
xlBarStacked = 58;
xlBarStacked100 = 59;
xl3DBarClustered = 60;
xl3DBarStacked = 61;
xl3DBarStacked100 = 62;
xlLineStacked = 63;
xlLineStacked100 = 64;
xlLineMarkers = 65;
xlLineMarkersStacked = 66;
xlLineMarkersStacked100 = 67;
xlPieOfPie = 68;
xlPieExploded = 69;
xl3DPieExploded = 70;
xlBarOfPie = 71;
xlXYScatterSmooth = 72;
xlXYScatterSmoothNoMarkers = 73;
xlXYScatterLines = 74;
xlXYScatterLinesNoMarkers = 75;
xlAreaStacked = 76;
xlAreaStacked100 = 77;
xl3DAreaStacked = 78;
xl3DAreaStacked100 = 79;
xlDoughnutExploded = 80;
xlRadarMarkers = 81;
xlRadarFilled = 82;
xlSurface = 83;
xlSurfaceWireframe = 84;
xlSurfaceTopView = 85;
xlSurfaceTopViewWireframe = 86;
xlBubble = 15;
xlBubble3DEffect = 87;
xlStockHLC = 88;
xlStockOHLC = 89;
xlStockVHLC = 90;
xlStockVOHLC = 91;
xlCylinderColClustered = 92;
xlCylinderColStacked = 93;
xlCylinderColStacked100 = 94;
xlCylinderBarClustered = 95;
xlCylinderBarStacked = 96;
xlCylinderBarStacked100 = 97;
xlCylinderCol = 98;
xlConeColClustered = 99;
xlConeColStacked = 100;
xlConeColStacked100 = 101;
xlConeBarClustered = 102;
xlConeBarStacked = 103;
xlConeBarStacked100 = 104;
xlConeCol = 105;
xlPyramidColClustered = 106;
xlPyramidColStacked = 107;
xlPyramidColStacked100 = 108;
xlPyramidBarClustered = 109;
xlPyramidBarStacked = 110;
xlPyramidBarStacked100 = 111;
xlPyramidCol = 112;
xl3DColumn = -4100;
xlLine = 4;
xl3DLine = -4101;
xl3DPie = -4102;
xlPie = 5;
xlXYScatter = -4169;
xl3DArea = -4098;
xlArea = 1;
xlDoughnut = -4120;
xlRadar = -4151;
※ Re:Excel常用枚举常量列表，对应的数字终于全成查了
mountain315发表评论于2006-3-25 18:34:00 个人主页 | 引用 | 返回 | 删除 | 回复
{ Various Constants }
xlAll = -4104;
xlAutomatic = -4105;
xlBoth = 1;
xlCenter = -4108;
xlChecker = 9;
xlCircle = 8;
xlCorner = 2;
xlCrissCross = 16;
xlCross = 4;
xlDiamond = 2;
xlDistributed = -4117;
xlDoubleAccounting = 5;
xlFixedvalue = 1;
xlFormats = -4122;
xlGray16 = 17;
xlGray8 = 18;
xlGrid = 15;
xlHigh = -4127;
xlInside = 2;
xlJustify = -4130;
xlLightDown = 13;
xlLightHorizontal = 11;
xlLightUp = 14;
xlLightVertical = 12;
xlLow = -4134;
xlManual = -4135;
xlMinusvalues = 3;
xlModule = -4141;
xlNextToAxis = 4;
xlNone = -4142;
xlNotes = -4144;
xlOff = -4146;
xlOn = 1;
xlPercent = 2;
xlPlus = 9;
xlPlusvalues = 2;
xlSemiGray75 = 10;
xlShowLabel = 4;
xlShowLabelAndPercent = 5;
xlShowPercent = 3;
xlShowvalue = 2;
xlSimple = -4154;
xlSingle = 2;
xlSingleAccounting = 4;
xlSolid = 1;
xlSquare = 1;
xlStar = 5;
xlStError = 4;
xlToolbarButton = 2;
xlTriangle = 3;
xlGray25 = -4124;
xlGray50 = -4125;
xlGray75 = -4126;
xlBottom = -4107;
xlLeft = -4131;
xlRight = -4152;
xlTop = -4160;
xl3DBar = -4099;
xl3DSurface = -4103;
xlBar = 2;
xlColumn = 3;
xlCombination = -4111;
xlCustom = -4114;
xlDefaultAutoFormat = -1;
xlMaximum = 2;
xlMinimum = 4;
xlOpaque = 3;
xlTransparent = 2;
xlBidi = -5000;
xlLatin = -5001;
xlContext = -5002;
xlLTR = -5003;
xlRTL = -5004;
xlVisualCursor = 2;
xlLogicalCursor = 1;
xlSystem = 1;
xlPartial = 3;
xlHindiNumerals = 3;
xlBidiCalendar = 3;
xlGregorian = 2;
xlComplete = 4;
xlScale = 3;
xlClosed = 3;
xlColor1 = 7;
xlColor2 = 8;
xlColor3 = 9;
xlConstants = 2;
xlContents = 2;
xlBelow = 1;
xlCascade = 7;
xlCenterAcrossSelection = 7;
xlChart4 = 2;
xlChartSeries = 17;
xlChartShort = 6;
xlChartTitles = 18;
xlClassic1 = 1;
xlClassic2 = 2;
xlClassic3 = 3;
xl3DEffects1 = 13;
xl3DEffects2 = 14;
xlAbove = 0;
xlAccounting1 = 4;
xlAccounting2 = 5;
xlAccounting3 = 6;
xlAccounting4 = 17;
xlAdd = 2;
xlDebugCodePane = 13;
xlDesktop = 9;
xlDirect = 1;
xlDivide = 5;
xlDoubleClosed = 5;
xlDoubleOpen = 4;
xlDoubleQuote = 1;
xlEntireChart = 20;
xlExcelMenus = 1;
xlExtended = 3;
xlFill = 5;
xlFirst = 0;
xlFloating = 5;
xlFormula = 5;
xlGeneral = 1;
xlGridline = 22;
xlIcons = 1;
xlImmediatePane = 12;
xlInteger = 2;
xlLast = 1;
xlLastCell = 11;
xlList1 = 10;
xlList2 = 11;
xlList3 = 12;
xlLocalFormat1 = 15;
xlLocalFormat2 = 16;
xlLong = 3;
xlLotusHelp = 2;
xlMacrosheetCell = 7;
xlMixed = 2;
xlMultiply = 4;
xlNarrow = 1;
xlNodocument． = 3;
xlOpen = 2;
xlOutside = 3;
xlReference = 4;
xlSemiautomatic = 2;
xlShort = 1;
xlSingleQuote = 2;
xlStrict = 2;
xlSubtract = 3;
xlTextBox = 16;
xlTiled = 1;
xlTitleBar = 8;
xlToolbar = 1;
xlVisible = 12;
xlWatchPane = 11;
xlWide = 3;
xlWorkbookTab = 6;
xlWorksheet4 = 1;
xlWorksheetCell = 3;
xlWorksheetShort = 5;
xlAllExceptBorders = 6;
xlLeftToRight = 2;
xlTopToBottom = 1;
xlVeryHidden = 2;
xlDrawingObject = 14;
※ Re:Excel常用枚举常量列表，对应的数字终于全成查了
mountain315发表评论于2006-3-25 21:19:00 个人主页 | 引用 | 返回 | 删除 | 回复
enum MsoLineDashStyle
{
    msoLineDashStyleMixed = -2,
    msoLineSolid = 1,
    msoLineSquareDot = 2,
    msoLineRoundDot = 3,
    msoLineDash = 4,
    msoLineDashDot = 5,
    msoLineDashDotDot = 6,
    msoLineLongDash = 7,
    msoLineLongDashDot = 8
};

enum MsoLineStyle
{
    msoLineStyleMixed = -2,
    msoLineSingle = 1,
    msoLineThinThin = 2,
    msoLineThinThick = 3,
    msoLineThickThin = 4,
    msoLineThickBetweenThin = 5
};

enum MsoArrowheadStyle
{
    msoArrowheadStyleMixed = -2,
    msoArrowheadNone = 1,
    msoArrowheadTriangle = 2,
    msoArrowheadOpen = 3,
    msoArrowheadStealth = 4,
    msoArrowheadDiamond = 5,
    msoArrowheadOval = 6
};

enum MsoArrowheadWidth
{
    msoArrowheadWidthMixed = -2,
    msoArrowheadNarrow = 1,
    msoArrowheadWidthMedium = 2,
    msoArrowheadWide = 3
};

enum MsoArrowheadLength
{
    msoArrowheadLengthMixed = -2,
    msoArrowheadShort = 1,
    msoArrowheadLengthMedium = 2,
    msoArrowheadLong = 3
};

enum MsoFillType
{
    msoFillMixed = -2,
    msoFillSolid = 1,
    msoFillPatterned = 2,
    msoFillGradient = 3,
    msoFillTextured = 4,
    msoFillBackground = 5,
    msoFillPicture = 6
};

enum MsoGradientStyle
{
    msoGradientMixed = -2,
    msoGradientHorizontal = 1,
    msoGradientVertical = 2,
    msoGradientDiagonalUp = 3,
    msoGradientDiagonalDown = 4,
    msoGradientFromCorner = 5,
    msoGradientFromTitle = 6,
    msoGradientFromCenter = 7
};

enum MsoGradientColorType
{
    msoGradientColorMixed = -2,
    msoGradientOneColor = 1,
    msoGradientTwoColors = 2,
    msoGradientPresetColors = 3
};

enum MsoTextureType
{
    msoTextureTypeMixed = -2,
    msoTexturePreset = 1,
    msoTextureUserDefined = 2
};
※ Re:Excel常用枚举常量列表，对应的数字终于全成查了
mountain315发表评论于2006-3-25 21:19:00 个人主页 | 引用 | 返回 | 删除 | 回复
enum MsoPresetTexture
{
    msoPresetTextureMixed = -2,
    msoTexturePapyrus = 1,
    msoTextureCanvas = 2,
    msoTextureDenim = 3,
    msoTextureWovenMat = 4,
    msoTextureWaterDroplets = 5,
    msoTexturePaperBag = 6,
    msoTextureFishFossil = 7,
    msoTextureSand = 8,
    msoTextureGreenMarble = 9,
    msoTextureWhiteMarble = 10,
    msoTextureBrownMarble = 11,
    msoTextureGranite = 12,
    msoTextureNewsprint = 13,
    msoTextureRecycledPaper = 14,
    msoTextureParchment = 15,
    msoTextureStationery = 16,
    msoTextureBlueTissuePaper = 17,
    msoTexturePinkTissuePaper = 18,
    msoTexturePurpleMesh = 19,
    msoTextureBouquet = 20,
    msoTextureCork = 21,
    msoTextureWalnut = 22,
    msoTextureOak = 23,
    msoTextureMediumWood = 24
};

enum MsoPatternType
{
    msoPatternMixed = -2,
    msoPattern5Percent = 1,
    msoPattern10Percent = 2,
    msoPattern20Percent = 3,
    msoPattern25Percent = 4,
    msoPattern30Percent = 5,
    msoPattern40Percent = 6,
    msoPattern50Percent = 7,
    msoPattern60Percent = 8,
    msoPattern70Percent = 9,
    msoPattern75Percent = 10,
    msoPattern80Percent = 11,
    msoPattern90Percent = 12,
    msoPatternDarkHorizontal = 13,
    msoPatternDarkVertical = 14,
    msoPatternDarkDownwardDiagonal = 15,
    msoPatternDarkUpwardDiagonal = 16,
    msoPatternSmallCheckerBoard = 17,
    msoPatternTrellis = 18,
    msoPatternLightHorizontal = 19,
    msoPatternLightVertical = 20,
    msoPatternLightDownwardDiagonal = 21,
    msoPatternLightUpwardDiagonal = 22,
    msoPatternSmallGrid = 23,
    msoPatternDottedDiamond = 24,
    msoPatternWideDownwardDiagonal = 25,
    msoPatternWideUpwardDiagonal = 26,
    msoPatternDashedUpwardDiagonal = 27,
    msoPatternDashedDownwardDiagonal = 28,
    msoPatternNarrowVertical = 29,
    msoPatternNarrowHorizontal = 30,
    msoPatternDashedVertical = 31,
    msoPatternDashedHorizontal = 32,
    msoPatternLargeConfetti = 33,
    msoPatternLargeGrid = 34,
    msoPatternHorizontalBrick = 35,
    msoPatternLargeCheckerBoard = 36,
    msoPatternSmallConfetti = 37,
    msoPatternZigZag = 38,
    msoPatternSolidDiamond = 39,
    msoPatternDiagonalBrick = 40,
    msoPatternOutlinedDiamond = 41,
    msoPatternPlaid = 42,
    msoPatternSphere = 43,
    msoPatternWeave = 44,
    msoPatternDottedGrid = 45,
    msoPatternDivot = 46,
    msoPatternShingle = 47,
    msoPatternWave = 48
};

enum MsoPresetGradientType
{
    msoPresetGradientMixed = -2,
    msoGradientEarlySunset = 1,
    msoGradientLateSunset = 2,
    msoGradientNightfall = 3,
    msoGradientDaybreak = 4,
    msoGradientHorizon = 5,
    msoGradientDesert = 6,
    msoGradientOcean = 7,
    msoGradientCalmWater = 8,
    msoGradientFire = 9,
    msoGradientFog = 10,
    msoGradientMoss = 11,
    msoGradientPeacock = 12,
    msoGradientWheat = 13,
    msoGradientParchment = 14,
    msoGradientMahogany = 15,
    msoGradientRainbow = 16,
    msoGradientRainbowII = 17,
    msoGradientGold = 18,
    msoGradientGoldII = 19,
    msoGradientBrass = 20,
    msoGradientChrome = 21,
    msoGradientChromeII = 22,
    msoGradientSilver = 23,
    msoGradientSapphire = 24
};
※ Re:Excel常用枚举常量列表，对应的数字终于全成查了
mountain315发表评论于2006-3-25 21:20:00 个人主页 | 引用 | 返回 | 删除 | 回复
enum MsoShadowType
{
    msoShadowMixed = -2,
    msoShadow1 = 1,
    msoShadow2 = 2,
    msoShadow3 = 3,
    msoShadow4 = 4,
    msoShadow5 = 5,
    msoShadow6 = 6,
    msoShadow7 = 7,
    msoShadow8 = 8,
    msoShadow9 = 9,
    msoShadow10 = 10,
    msoShadow11 = 11,
    msoShadow12 = 12,
    msoShadow13 = 13,
    msoShadow14 = 14,
    msoShadow15 = 15,
    msoShadow16 = 16,
    msoShadow17 = 17,
    msoShadow18 = 18,
    msoShadow19 = 19,
    msoShadow20 = 20
};

enum MsoPresetTextEffect
{
    msoTextEffectMixed = -2,
    msoTextEffect1 = 0,
    msoTextEffect2 = 1,
    msoTextEffect3 = 2,
    msoTextEffect4 = 3,
    msoTextEffect5 = 4,
    msoTextEffect6 = 5,
    msoTextEffect7 = 6,
    msoTextEffect8 = 7,
    msoTextEffect9 = 8,
    msoTextEffect10 = 9,
    msoTextEffect11 = 10,
    msoTextEffect12 = 11,
    msoTextEffect13 = 12,
    msoTextEffect14 = 13,
    msoTextEffect15 = 14,
    msoTextEffect16 = 15,
    msoTextEffect17 = 16,
    msoTextEffect18 = 17,
    msoTextEffect19 = 18,
    msoTextEffect20 = 19,
    msoTextEffect21 = 20,
    msoTextEffect22 = 21,
    msoTextEffect23 = 22,
    msoTextEffect24 = 23,
    msoTextEffect25 = 24,
    msoTextEffect26 = 25,
    msoTextEffect27 = 26,
    msoTextEffect28 = 27,
    msoTextEffect29 = 28,
    msoTextEffect30 = 29
};

enum MsoPresetTextEffectShape
{
    msoTextEffectShapeMixed = -2,
    msoTextEffectShapePlainText = 1,
    msoTextEffectShapeStop = 2,
    msoTextEffectShapeTriangleUp = 3,
    msoTextEffectShapeTriangleDown = 4,
    msoTextEffectShapeChevronUp = 5,
    msoTextEffectShapeChevronDown = 6,
    msoTextEffectShapeRingInside = 7,
    msoTextEffectShapeRingOutside = 8,
    msoTextEffectShapeArchUpCurve = 9,
    msoTextEffectShapeArchDownCurve = 10,
    msoTextEffectShapeCircleCurve = 11,
    msoTextEffectShapeButtonCurve = 12,
    msoTextEffectShapeArchUpPour = 13,
    msoTextEffectShapeArchDownPour = 14,
    msoTextEffectShapeCirclePour = 15,
    msoTextEffectShapeButtonPour = 16,
    msoTextEffectShapeCurveUp = 17,
    msoTextEffectShapeCurveDown = 18,
    msoTextEffectShapeCanUp = 19,
    msoTextEffectShapeCanDown = 20,
    msoTextEffectShapeWave1 = 21,
    msoTextEffectShapeWave2 = 22,
    msoTextEffectShapeDoubleWave1 = 23,
    msoTextEffectShapeDoubleWave2 = 24,
    msoTextEffectShapeInflate = 25,
    msoTextEffectShapeDeflate = 26,
    msoTextEffectShapeInflateBottom = 27,
    msoTextEffectShapeDeflateBottom = 28,
    msoTextEffectShapeInflateTop = 29,
    msoTextEffectShapeDeflateTop = 30,
    msoTextEffectShapeDeflateInflate = 31,
    msoTextEffectShapeDeflateInflateDeflate = 32,
    msoTextEffectShapeFadeRight = 33,
    msoTextEffectShapeFadeLeft = 34,
    msoTextEffectShapeFadeUp = 35,
    msoTextEffectShapeFadeDown = 36,
    msoTextEffectShapeSlantUp = 37,
    msoTextEffectShapeSlantDown = 38,
    msoTextEffectShapeCascadeUp = 39,
    msoTextEffectShapeCascadeDown = 40
};
※ Re:Excel常用枚举常量列表，对应的数字终于全成查了
mountain315发表评论于2006-3-25 21:20:00 个人主页 | 引用 | 返回 | 删除 | 回复
enum MsoTextEffectAlignment
{
    msoTextEffectAlignmentMixed = -2,
    msoTextEffectAlignmentLeft = 1,
    msoTextEffectAlignmentCentered = 2,
    msoTextEffectAlignmentRight = 3,
    msoTextEffectAlignmentLetterJustify = 4,
    msoTextEffectAlignmentWordJustify = 5,
    msoTextEffectAlignmentStretchJustify = 6
};

enum MsoPresetLightingDirection
{
    msoPresetLightingDirectionMixed = -2,
    msoLightingTopLeft = 1,
    msoLightingTop = 2,
    msoLightingTopRight = 3,
    msoLightingLeft = 4,
    msoLightingNone = 5,
    msoLightingRight = 6,
    msoLightingBottomLeft = 7,
    msoLightingBottom = 8,
    msoLightingBottomRight = 9
};

enum MsoPresetLightingSoftness
{
    msoPresetLightingSoftnessMixed = -2,
    msoLightingDim = 1,
    msoLightingNormal = 2,
    msoLightingBright = 3
};

enum MsoPresetMaterial
{
    msoPresetMaterialMixed = -2,
    msoMaterialMatte = 1,
    msoMaterialPlastic = 2,
    msoMaterialMetal = 3,
    msoMaterialWireFrame = 4
};

enum MsoPresetExtrusionDirection
{
    msoPresetExtrusionDirectionMixed = -2,
    msoExtrusionBottomRight = 1,
    msoExtrusionBottom = 2,
    msoExtrusionBottomLeft = 3,
    msoExtrusionRight = 4,
    msoExtrusionNone = 5,
    msoExtrusionLeft = 6,
    msoExtrusionTopRight = 7,
    msoExtrusionTop = 8,
    msoExtrusionTopLeft = 9
};

enum MsoPresetThreeDFormat
{
    msoPresetThreeDFormatMixed = -2,
    msoThreeD1 = 1,
    msoThreeD2 = 2,
    msoThreeD3 = 3,
    msoThreeD4 = 4,
    msoThreeD5 = 5,
    msoThreeD6 = 6,
    msoThreeD7 = 7,
    msoThreeD8 = 8,
    msoThreeD9 = 9,
    msoThreeD10 = 10,
    msoThreeD11 = 11,
    msoThreeD12 = 12,
    msoThreeD13 = 13,
    msoThreeD14 = 14,
    msoThreeD15 = 15,
    msoThreeD16 = 16,
    msoThreeD17 = 17,
    msoThreeD18 = 18,
    msoThreeD19 = 19,
    msoThreeD20 = 20
};

enum MsoExtrusionColorType
{
    msoExtrusionColorTypeMixed = -2,
    msoExtrusionColorAutomatic = 1,
    msoExtrusionColorCustom = 2
};

enum MsoAlignCmd
{
    msoAlignLefts = 0,
    msoAlignCenters = 1,
    msoAlignRights = 2,
    msoAlignTops = 3,
    msoAlignMiddles = 4,
    msoAlignBottoms = 5
};

enum MsoDistributeCmd
{
    msoDistributeHorizontally = 0,
    msoDistributeVertically = 1
};

enum MsoConnectorType
{
    msoConnectorTypeMixed = -2,
    msoConnectorStraight = 1,
    msoConnectorElbow = 2,
    msoConnectorCurve = 3
};

enum MsoHorizontalAnchor
{
    msoHorizontalAnchorMixed = -2,
    msoAnchorNone = 1,
    msoAnchorCenter = 2
};

enum MsoVerticalAnchor
{
    msoVerticalAnchorMixed = -2,
    msoAnchorTop = 1,
    msoAnchorTopBaseline = 2,
    msoAnchorMiddle = 3,
    msoAnchorBottom = 4,
    msoAnchorBottomBaseLine = 5
};
※ Re:Excel常用枚举常量列表，对应的数字终于全成查了
mountain315发表评论于2006-3-25 21:21:00 个人主页 | 引用 | 返回 | 删除 | 回复
enum MsoOrientation
{
    msoOrientationMixed = -2,
    msoOrientationHorizontal = 1,
    msoOrientationVertical = 2
};

enum MsoZOrderCmd
{
    msoBringToFront = 0,
    msoSendToBack = 1,
    msoBringForward = 2,
    msoSendBackward = 3,
    msoBringInFrontOfText = 4,
    msoSendBehindText = 5
};

enum MsoSegmentType
{
    msoSegmentLine = 0,
    msoSegmentCurve = 1
};

enum MsoEditingType
{
    msoEditingAuto = 0,
    msoEditingCorner = 1,
    msoEditingSmooth = 2,
    msoEditingSymmetric = 3
};
※ Re:Excel常用枚举常量列表，对应的数字终于全成查了
mountain315发表评论于2006-3-25 21:21:00 个人主页 | 引用 | 返回 | 删除 | 回复
enum MsoAutoShapeType
{
    msoShapeMixed = -2,
    msoShapeRectangle = 1,
    msoShapeParallelogram = 2,
    msoShapeTrapezoid = 3,
    msoShapeDiamond = 4,
    msoShapeRoundedRectangle = 5,
    msoShapeOctagon = 6,
    msoShapeIsoscelesTriangle = 7,
    msoShapeRightTriangle = 8,
    msoShapeOval = 9,
    msoShapeHexagon = 10,
    msoShapeCross = 11,
    msoShapeRegularPentagon = 12,
    msoShapeCan = 13,
    msoShapeCube = 14,
    msoShapeBevel = 15,
    msoShapeFoldedCorner = 16,
    msoShapeSmileyFace = 17,
    msoShapeDonut = 18,
    msoShapeNoSymbol = 19,
    msoShapeBlockArc = 20,
    msoShapeHeart = 21,
    msoShapeLightningBolt = 22,
    msoShapeSun = 23,
    msoShapeMoon = 24,
    msoShapeArc = 25,
    msoShapeDoubleBracket = 26,
    msoShapeDoubleBrace = 27,
    msoShapePlaque = 28,
    msoShapeLeftBracket = 29,
    msoShapeRightBracket = 30,
    msoShapeLeftBrace = 31,
    msoShapeRightBrace = 32,
    msoShapeRightArrow = 33,
    msoShapeLeftArrow = 34,
    msoShapeUpArrow = 35,
    msoShapeDownArrow = 36,
    msoShapeLeftRightArrow = 37,
    msoShapeUpDownArrow = 38,
    msoShapeQuadArrow = 39,
    msoShapeLeftRightUpArrow = 40,
    msoShapeBentArrow = 41,
    msoShapeUTurnArrow = 42,
    msoShapeLeftUpArrow = 43,
    msoShapeBentUpArrow = 44,
    msoShapeCurvedRightArrow = 45,
    msoShapeCurvedLeftArrow = 46,
    msoShapeCurvedUpArrow = 47,
    msoShapeCurvedDownArrow = 48,
    msoShapeStripedRightArrow = 49,
    msoShapeNotchedRightArrow = 50,
    msoShapePentagon = 51,
    msoShapeChevron = 52,
    msoShapeRightArrowCallout = 53,
    msoShapeLeftArrowCallout = 54,
    msoShapeUpArrowCallout = 55,
    msoShapeDownArrowCallout = 56,
    msoShapeLeftRightArrowCallout = 57,
※ Re:Excel常用枚举常量列表，对应的数字终于全成查了
mountain315发表评论于2006-3-25 21:22:00 个人主页 | 引用 | 返回 | 删除 | 回复
    msoShapeUpDownArrowCallout = 58,
    msoShapeQuadArrowCallout = 59,
    msoShapeCircularArrow = 60,
    msoShapeFlowchartProcess = 61,
    msoShapeFlowchartAlternateProcess = 62,
    msoShapeFlowchartDecision = 63,
    msoShapeFlowchartData = 64,
    msoShapeFlowchartPredefinedProcess = 65,
    msoShapeFlowchartInternalStorage = 66,
    msoShapeFlowchartDocument = 67,
    msoShapeFlowchartMultidocument = 68,
    msoShapeFlowchartTerminator = 69,
    msoShapeFlowchartPreparation = 70,
    msoShapeFlowchartManualInput = 71,
    msoShapeFlowchartManualOperation = 72,
    msoShapeFlowchartConnector = 73,
    msoShapeFlowchartOffpageConnector = 74,
    msoShapeFlowchartCard = 75,
    msoShapeFlowchartPunchedTape = 76,
    msoShapeFlowchartSummingJunction = 77,
    msoShapeFlowchartOr = 78,
    msoShapeFlowchartCollate = 79,
    msoShapeFlowchartSort = 80,
    msoShapeFlowchartExtract = 81,
    msoShapeFlowchartMerge = 82,
    msoShapeFlowchartStoredData = 83,
    msoShapeFlowchartDelay = 84,
    msoShapeFlowchartSequentialAccessStorage = 85,
    msoShapeFlowchartMagneticDisk = 86,
    msoShapeFlowchartDirectAccessStorage = 87,
    msoShapeFlowchartDisplay = 88,
    msoShapeExplosion1 = 89,
    msoShapeExplosion2 = 90,
    msoShape4pointStar = 91,
    msoShape5pointStar = 92,
    msoShape8pointStar = 93,
    msoShape16pointStar = 94,
    msoShape24pointStar = 95,
    msoShape32pointStar = 96,
    msoShapeUpRibbon = 97,
    msoShapeDownRibbon = 98,
    msoShapeCurvedUpRibbon = 99,
    msoShapeCurvedDownRibbon = 100,
    msoShapeVerticalScroll = 101,
    msoShapeHorizontalScroll = 102,
    msoShapeWave = 103,
    msoShapeDoubleWave = 104,
    msoShapeRectangularCallout = 105,
    msoShapeRoundedRectangularCallout = 106,
    msoShapeOvalCallout = 107,
    msoShapeCloudCallout = 108,
    msoShapeLineCallout1 = 109,
    msoShapeLineCallout2 = 110,
    msoShapeLineCallout3 = 111,
    msoShapeLineCallout4 = 112,
    msoShapeLineCallout1AccentBar = 113,
    msoShapeLineCallout2AccentBar = 114,
    msoShapeLineCallout3AccentBar = 115,
    msoShapeLineCallout4AccentBar = 116,
    msoShapeLineCallout1NoBorder = 117,
    msoShapeLineCallout2NoBorder = 118,
    msoShapeLineCallout3NoBorder = 119,
    msoShapeLineCallout4NoBorder = 120,
    msoShapeLineCallout1BorderandAccentBar = 121,
    msoShapeLineCallout2BorderandAccentBar = 122,
    msoShapeLineCallout3BorderandAccentBar = 123,
    msoShapeLineCallout4BorderandAccentBar = 124,
    msoShapeActionButtonCustom = 125,
    msoShapeActionButtonHome = 126,
    msoShapeActionButtonHelp = 127,
    msoShapeActionButtonInformation = 128,
    msoShapeActionButtonBackorPrevious = 129,
    msoShapeActionButtonForwardorNext = 130,
    msoShapeActionButtonBeginning = 131,
    msoShapeActionButtonEnd = 132,
    msoShapeActionButtonReturn = 133,
    msoShapeActionButtonDocument = 134,
    msoShapeActionButtonSound = 135,
    msoShapeActionButtonMovie = 136,
    msoShapeBalloon = 137,
    msoShapeNotPrimitive = 138
};
※ Re:Excel常用枚举常量列表，对应的数字终于全成查了
mountain315发表评论于2006-3-25 21:22:00 个人主页 | 引用 | 返回 | 删除 | 回复
enum MsoShapeType
{
    msoShapeTypeMixed = -2,
    msoAutoShape = 1,
    msoCallout = 2,
    msoChart = 3,
    msoComment = 4,
    msoFreeform = 5,
    msoGroup = 6,
    msoEmbeddedOLEObject = 7,
    msoFormControl = 8,
    msoLine = 9,
    msoLinkedOLEObject = 10,
    msoLinkedPicture = 11,
    msoOLEControlObject = 12,
    msoPicture = 13,
    msoPlaceholder = 14,
    msoTextEffect = 15,
    msoMedia = 16,
    msoTextBox = 17,
    msoScriptAnchor = 18,
    msoTable = 19,
    msoCanvas = 20,
    msoDiagram = 21
};

enum MsoFlipCmd
{
    msoFlipHorizontal = 0,
    msoFlipVertical = 1
};

enum MsoTriState
{
    msoTrue = -1,
    msoFalse = 0,
    msoCTrue = 1,
    msoTriStateToggle = -3,
    msoTriStateMixed = -2
};

enum MsoColorType
{
    msoColorTypeMixed = -2,
    msoColorTypeRGB = 1,
    msoColorTypeScheme = 2,
    msoColorTypeCMYK = 3,
    msoColorTypeCMS = 4,
    msoColorTypeInk = 5
};

enum MsoPictureColorType
{
    msoPictureMixed = -2,
    msoPictureAutomatic = 1,
    msoPictureGrayscale = 2,
    msoPictureBlackAndWhite = 3,
    msoPictureWatermark = 4
};

enum MsoCalloutAngleType
{
    msoCalloutAngleMixed = -2,
    msoCalloutAngleAutomatic = 1,
    msoCalloutAngle30 = 2,
    msoCalloutAngle45 = 3,
    msoCalloutAngle60 = 4,
    msoCalloutAngle90 = 5
};

enum MsoCalloutDropType
{
    msoCalloutDropMixed = -2,
    msoCalloutDropCustom = 1,
    msoCalloutDropTop = 2,
    msoCalloutDropCenter = 3,
    msoCalloutDropBottom = 4
};
※ Re:Excel常用枚举常量列表，对应的数字终于全成查了
mountain315发表评论于2006-3-25 21:22:00 个人主页 | 引用 | 返回 | 删除 | 回复
enum MsoCalloutType
{
    msoCalloutMixed = -2,
    msoCalloutOne = 1,
    msoCalloutTwo = 2,
    msoCalloutThree = 3,
    msoCalloutFour = 4
};

enum MsoBlackWhiteMode
{
    msoBlackWhiteMixed = -2,
    msoBlackWhiteAutomatic = 1,
    msoBlackWhiteGrayScale = 2,
    msoBlackWhiteLightGrayScale = 3,
    msoBlackWhiteInverseGrayScale = 4,
    msoBlackWhiteGrayOutline = 5,
    msoBlackWhiteBlackTextAndLine = 6,
    msoBlackWhiteHighContrast = 7,
    msoBlackWhiteBlack = 8,
    msoBlackWhiteWhite = 9,
    msoBlackWhiteDontShow = 10
};

enum MsoMixedType
{
    msoIntegerMixed = 32768,
    msoSingleMixed = -2147483648
};

enum MsoTextOrientation
{
    msoTextOrientationMixed = -2,
    msoTextOrientationHorizontal = 1,
    msoTextOrientationUpward = 2,
    msoTextOrientationDownward = 3,
    msoTextOrientationVerticalFarEast = 4,
    msoTextOrientationVertical = 5,
    msoTextOrientationHorizontalRotatedFarEast = 6
};

enum MsoScaleFrom
{
    msoScaleFromTopLeft = 0,
    msoScaleFromMiddle = 1,
    msoScaleFromBottomRight = 2
};

enum MsoBarPosition
{
    msoBarLeft = 0,
    msoBarTop = 1,
    msoBarRight = 2,
    msoBarBottom = 3,
    msoBarFloating = 4,
    msoBarPopup = 5,
    msoBarMenuBar = 6
};

enum MsoBarProtection
{
    msoBarNoProtection = 0,
    msoBarNoCustomize = 1,
    msoBarNoResize = 2,
    msoBarNoMove = 4,
    msoBarNoChangeVisible = 8,
    msoBarNoChangeDock = 16,
    msoBarNoVerticalDock = 32,
    msoBarNoHorizontalDock = 64
};

enum MsoBarType
{
    msoBarTypeNormal = 0,
    msoBarTypeMenuBar = 1,
    msoBarTypePopup = 2
};

enum MsoControlType
{
    msoControlCustom = 0,
    msoControlButton = 1,
    msoControlEdit = 2,
    msoControlDropdown = 3,
    msoControlComboBox = 4,
    msoControlButtonDropdown = 5,
    msoControlSplitDropdown = 6,
    msoControlOCXDropdown = 7,
    msoControlGenericDropdown = 8,
    msoControlGraphicDropdown = 9,
    msoControlPopup = 10,
    msoControlGraphicPopup = 11,
    msoControlButtonPopup = 12,
    msoControlSplitButtonPopup = 13,
    msoControlSplitButtonMRUPopup = 14,
    msoControlLabel = 15,
    msoControlExpandingGrid = 16,
    msoControlSplitExpandingGrid = 17,
    msoControlGrid = 18,
    msoControlGauge = 19,
    msoControlGraphicCombo = 20,
    msoControlPane = 21,
    msoControlActiveX = 22,
    msoControlSpinner = 23,
    msoControlLabelEx = 24,
    msoControlWorkPane = 25,
    msoControlAutoCompleteCombo = 26
};
※ Re:Excel常用枚举常量列表，对应的数字终于全成查了
mountain315发表评论于2006-3-25 21:22:00 个人主页 | 引用 | 返回 | 删除 | 回复
enum MsoButtonState
{
    msoButtonUp = 0,
    msoButtonDown = -1,
    msoButtonMixed = 2
};

enum MsoControlOLEUsage
{
    msoControlOLEUsageNeither = 0,
    msoControlOLEUsageServer = 1,
    msoControlOLEUsageClient = 2,
    msoControlOLEUsageBoth = 3
};

enum MsoButtonStyleHidden
{
    msoButtonWrapText = 4,
    msoButtonTextBelow = 8
};

enum MsoButtonStyle
{
    msoButtonAutomatic = 0,
    msoButtonIcon = 1,
    msoButtonCaption = 2,
    msoButtonIconAndCaption = 3,
    msoButtonIconAndWrapCaption = 7,
    msoButtonIconAndCaptionBelow = 11,
    msoButtonWrapCaption = 14,
    msoButtonIconAndWrapCaptionBelow = 15
};

enum MsoComboStyle
{
    msoComboNormal = 0,
    msoComboLabel = 1
};

enum MsoOLEMenuGroup
{
    msoOLEMenuGroupNone = -1,
    msoOLEMenuGroupFile = 0,
    msoOLEMenuGroupEdit = 1,
    msoOLEMenuGroupContainer = 2,
    msoOLEMenuGroupObject = 3,
    msoOLEMenuGroupWindow = 4,
    msoOLEMenuGroupHelp = 5
};

enum MsoMenuAnimation
{
    msoMenuAnimationNone = 0,
    msoMenuAnimationRandom = 1,
    msoMenuAnimationUnfold = 2,
    msoMenuAnimationSlide = 3
};

enum MsoBarRow
{
    msoBarRowFirst = 0,
    msoBarRowLast = -1
};

enum MsoCommandBarButtonHyperlinkType
{
    msoCommandBarButtonHyperlinkNone = 0,
    msoCommandBarButtonHyperlinkOpen = 1,
    msoCommandBarButtonHyperlinkInsertPicture = 2
};

enum MsoHyperlinkType
{
    msoHyperlinkRange = 0,
    msoHyperlinkShape = 1,
    msoHyperlinkInlineShape = 2
};

enum MsoExtraInfoMethod
{
    msoMethodGet = 0,
    msoMethodPost = 1
};

enum MsoAnimationType
{
    msoAnimationIdle = 1,
    msoAnimationGreeting = 2,
    msoAnimationGoodbye = 3,
    msoAnimationBeginSpeaking = 4,
    msoAnimationRestPose = 5,
    msoAnimationCharacterSuccessMajor = 6,
    msoAnimationGetAttentionMajor = 11,
    msoAnimationGetAttentionMinor = 12,
    msoAnimationSearching = 13,
    msoAnimationPrinting = 18,
    msoAnimationGestureRight = 19,
    msoAnimationWritingNotingSomething = 22,
    msoAnimationWorkingAtSomething = 23,
    msoAnimationThinking = 24,
    msoAnimationSendingMail = 25,
    msoAnimationListensToComputer = 26,
    msoAnimationDisappear = 31,
    msoAnimationAppear = 32,
    msoAnimationGetArtsy = 100,
    msoAnimationGetTechy = 101,
    msoAnimationGetWizardy = 102,
    msoAnimationCheckingSomething = 103,
    msoAnimationLookDown = 104,
    msoAnimationLookDownLeft = 105,
    msoAnimationLookDownRight = 106,
    msoAnimationLookLeft = 107,
    msoAnimationLookRight = 108,
    msoAnimationLookUp = 109,
    msoAnimationLookUpLeft = 110,
    msoAnimationLookUpRight = 111,
    msoAnimationSaving = 112,
    msoAnimationGestureDown = 113,
    msoAnimationGestureLeft = 114,
    msoAnimationGestureUp = 115,
    msoAnimationEmptyTrash = 116
};
※ Re:Excel常用枚举常量列表，对应的数字终于全成查了
mountain315发表评论于2006-3-25 21:23:00 个人主页 | 引用 | 返回 | 删除 | 回复
enum MsoButtonSetType
{
    msoButtonSetNone = 0,
    msoButtonSetOK = 1,
    msoButtonSetCancel = 2,
    msoButtonSetOkCancel = 3,
    msoButtonSetYesNo = 4,
    msoButtonSetYesNoCancel = 5,
    msoButtonSetBackClose = 6,
    msoButtonSetNextClose = 7,
    msoButtonSetBackNextClose = 8,
    msoButtonSetRetryCancel = 9,
    msoButtonSetAbortRetryIgnore = 10,
    msoButtonSetSearchClose = 11,
    msoButtonSetBackNextSnooze = 12,
    msoButtonSetTipsOptionsClose = 13,
    msoButtonSetYesAllNoCancel = 14
};

enum MsoIconType
{
    msoIconNone = 0,
    msoIconAlert = 2,
    msoIconTip = 3,
    msoIconAlertInfo = 4,
    msoIconAlertWarning = 5,
    msoIconAlertQuery = 6,
    msoIconAlertCritical = 7
};

enum MsoBalloonType
{
    msoBalloonTypeButtons = 0,
    msoBalloonTypeBullets = 1,
    msoBalloonTypeNumbers = 2
};

enum MsoModeType
{
    msoModeModal = 0,
    msoModeAutoDown = 1,
    msoModeModeless = 2
};

enum MsoBalloonErrorType
{
    msoBalloonErrorNone = 0,
    msoBalloonErrorOther = 1,
    msoBalloonErrorTooBig = 2,
    msoBalloonErrorOutOfMemory = 3,
    msoBalloonErrorBadPictureRef = 4,
    msoBalloonErrorBadReference = 5,
    msoBalloonErrorButtonlessModal = 6,
    msoBalloonErrorButtonModeless = 7,
    msoBalloonErrorBadCharacter = 8,
    msoBalloonErrorCOMFailure = 9,
    msoBalloonErrorCharNotTopmostForModal = 10,
    msoBalloonErrorTooManyControls = 11
};

enum MsoWizardActType
{
    msoWizardActInactive = 0,
    msoWizardActActive = 1,
    msoWizardActSuspend = 2,
    msoWizardActResume = 3
};

enum MsoWizardMsgType
{
    msoWizardMsgLocalStateOn = 1,
    msoWizardMsgLocalStateOff = 2,
    msoWizardMsgShowHelp = 3,
    msoWizardMsgSuspending = 4,
    msoWizardMsgResuming = 5
};

enum MsoBalloonButtonType
{
    msoBalloonButtonYesToAll = -15,
    msoBalloonButtonOptions = -14,
    msoBalloonButtonTips = -13,
    msoBalloonButtonClose = -12,
    msoBalloonButtonSnooze = -11,
    msoBalloonButtonSearch = -10,
    msoBalloonButtonIgnore = -9,
    msoBalloonButtonAbort = -8,
    msoBalloonButtonRetry = -7,
    msoBalloonButtonNext = -6,
    msoBalloonButtonBack = -5,
    msoBalloonButtonNo = -4,
    msoBalloonButtonYes = -3,
    msoBalloonButtonCancel = -2,
    msoBalloonButtonOK = -1,
    msoBalloonButtonNull = 0
};

enum DocProperties
{
    offPropertyTypeNumber = 1,
    offPropertyTypeBoolean = 2,
    offPropertyTypeDate = 3,
    offPropertyTypeString = 4,
    offPropertyTypeFloat = 5
};

enum MsoDocProperties
{
    msoPropertyTypeNumber = 1,
    msoPropertyTypeBoolean = 2,
    msoPropertyTypeDate = 3,
    msoPropertyTypeString = 4,
    msoPropertyTypeFloat = 5
};

enum MsoAppLanguageID
{
    msoLanguageIDInstall = 1,
    msoLanguageIDUI = 2,
    msoLanguageIDHelp = 3,
    msoLanguageIDExeMode = 4,
    msoLanguageIDUIPrevious = 5
};

enum MsoFarEastLineBreakLanguageID
{
    MsoFarEastLineBreakLanguageJapanese = 1041,
    MsoFarEastLineBreakLanguageKorean = 1042,
    MsoFarEastLineBreakLanguageSimplifiedChinese = 2052,
    MsoFarEastLineBreakLanguageTraditionalChinese = 1028
};

enum MsoFeatureInstall
{
    msoFeatureInstallNone = 0,
    msoFeatureInstallOnDemand = 1,
    msoFeatureInstallOnDemandWithUI = 2
};
※ Re:Excel常用枚举常量列表，对应的数字终于全成查了
mountain315发表评论于2006-4-5 12:54:00 个人主页 | 引用 | 返回 | 删除 | 回复
以下是引用huangshuchun在2006-4-5 12:39:00的发言：
对VBA常量的值可以在打开Word或者Excel后按Alt + F11键调出VBA编辑器,然后再按F2打开对象浏览器，输入常量名称就可以查了

 

发表评论：

    昵称：
    密码：
    主页：
    标题：
Powered by Oblog.