vba的对象属性大全.xls

第1章Application对象 当前操作系统的名称和版本号 当前的注册组织名 计算机名 当前用户名 启动微软的应用程序 当前剩余内存 当前MicrosoftExcel的总内存 被Excel使用的内存 Excel版本 Excel安装路径 启动Excel的路径 打开Excel文件时使用的默认路径 模板保存的默认路径 库文件夹的路径 路径分隔符 设置文件清单中的最多文件数 设置新工作簿中的工作表个数 设置文件的默认位置 打开Excel帮助文件 Excel全屏显示 Excel窗口显示 Excel窗口位置 在主窗口中所能占有的最大高度和宽 度 隐藏显示Excel Excel标题设置 设置状态栏中的文字 隐藏显示状态栏 隐藏显示编辑栏 隐藏显示常用工具栏 隐藏显示格式工具栏 隐藏显示任务窗格 更改鼠标指针形状 撤消上次操作 自动手动计算 切换引用样式 按回车切换单元格移动方向 禁用Ctrl Break中止宏运行的功能 禁止在单元格中直接编辑 屏幕刷新 指定对象禁用启用事件 禁用启用Esc键捕获功能 关闭显示警告信息框 清空剪贴板 安装指定加载宏 打开内置对话框 用户输入的对话框 显示消息对话框 运行宏 一段时间后运行宏 某时间运行宏 制定宏运行的时间计划 取消运行计划 退出Excel Application OperatingSystem Application OrganizationName Environ computername Application UserName Environ Username Application ActivateMicrosoftApp x x为 xlMicrosoftWord xlMicrosoftPowerPoint xlMicrosoftMail xlMicrosoftAccess xlMicrosoftFoxPro xlMicrosoftProject xlMicrosoftSchedulePlus Application MemoryFree Application MemoryTotal Application MemoryUsed Application Version Application Path Application StartupPath Application DefaultFilePath Application TemplatesPath Application LibraryPath Application PathSeparator Application RecentFiles Maximum n Application SheetsInNewWorkbook n Application DefaultFilePath 路径 Application Help Application DisplayFullScreen True Application DisplayFullScreen False Application WindowState x x为 xlMaximized xlMinimized xlNormal Application Height Application Width Application Left Application Top Application UsableHeight Application UsableWidth Application Visible False True Application Caption 修改标题 Application Caption vbNullString恢复默认 Application Caption vbNullChar删除标题 Application StatusBar Application StatusBar False Application DisplayStatusBar False True Application DisplayFormulaBar False True Application CommandBars Standard Visible False True Application CommandBars Formatting Visible False True Application CommandBars TaskPane Visible False True Application Cursor x x为 xlWait沙漏型指针 xlIBeamI 型指针 xlNorthwestArrow西北向箭头指针 xlDefault恢复默认 Application Undo Application Calculation x x为 xlCalculationAutomatic自动计算 xlCalculationManual手动计算 xlCalculationSemiautomatic 除模拟运算表外 自动计算 Application ReferenceStyle xlA1A1引用样式 Application ReferenceStyle xlR1C1R1C1引用样式 Application MoveAfterReturn True按下Enter活动单元格的位置可以改变 Application MoveAfterReturnDirection x x为 向右移动 xlToRight 向下移动 xlDown 向左移动 xlToLeft 向上移动 xlUp Application Enable CancelKey xlDisabled Application EditDirectlyInCell False True Application ScreenUpdating False True Application EnableEvents False True Application EnableCancelKey xlDisabled Application EnableCancelKey xlInterrupt Application DisplayAlerts False True Application CutCopyMode False True Application AddIns 加载宏名 Installed True Application Dialogs n Show 值n为 1 xlDialogOpen 5 xlDialogSaveAs 7 xlDialogPageSetup 8 xlDialogPrint 9 xlDialogPrinterSetup 17 xlDialogRun 23 xlDialogSetPrintTitles 26 xlDialogFont 27 xlDialogDisplay 41 xlDialogTable 42 xlDialogFormatNumber 45 xlDialogBorder 46 xlDialogCellProtection 47 xlDialogColumnWidth 52 xlDialogClear 55 xlDialogInsert 61 xlDialogDefineName 84 xlDialogPatterns 111 xlDialogDeleteFormat 119 xlDialogNew 127 xlDialogRowHeight 189 xlDialogSendMail 222 xlDialogPrintPreview 229 xlDialogDefineStyle 282 xlDialogWorkbookMove 283 xlDialogWorkbookCopy 302 xlDialogWorkbookNew 342 xlDialogInsertPicture 354 xlDialogWorkbookInsert 386 xlDialogWorkbookName 417 xlDialogWorkbookProtect 476 xlDialogActiveCellFont 509 xlDialogSetBackgroundPicture 583 xlDialogConditionalFormatting 596 xlDialogInsertHyperlink Selection Value Application InputBox Prompt myPrompt Title myTitle Type 0 Selection Value Application InputBox Prompt myPrompt Title myTitle Type 1 Selection Value Application InputBox Prompt myPrompt Title myTitle Type 2 Application InputBox Prompt myPrompt Title myTitle Default myDefau lt Type 8 Application InputBox Prompt myPrompt Title myTitle Type 1 2 Application InputBox Prompt myPrompt Title myTitle Default myDefau lt Type 2 a MsgBox 信息 x1 x2 x3 x4 标题 x1为 0 vbOKOnly 1 VbOKCancel 2 VbAbortRetryIgnore 3 VbYesNoCancel 4 VbYesNo 5 VbRetryCancel x2为 16 VbCritical 32 VbQuestion 48 VbExclamation 64 VbInformation x3为 0 vbDefaultButton1 256 vbDefaultButton2 512 vbDefaultButton3 768 vbDefaultButton4 x4为 16384 vbMsgBoxHelpButton 524288 vbMsgBoxRight a返回为 1 vbOK 2 vbCancel 3 vbAbort 4 vbRetry 5 vbIgnore 6 vbYes 7 vbNo Application Run宏名 Application OnTimeNow TimeValue 00 00 05 宏名 Application OnTimeTimeValue 0 00 00 宏名 Application OnTimeEarliestTime NextTime Procedure 宏名 Application OnTimeEarliestTime TimeValue 00 00 00 Procedure 宏名 Schedule False Application Quit 除模拟运算表外 自动计算 按下Enter活动单元格的位置可以改变 Application OnTimeEarliestTime TimeValue 00 00 00 Procedure 宏名 Schedule False 第2章 Wordbook 工作簿 对象 工作簿名Workbooks 1 Name 当前活动工作簿名ActiveWorkbook Name ThisWorkbook Name 当前完整路径的工作簿名ThisWorkbook FullName 本工作簿的基本名称Left ThisWorkbook Name InStr ThisWorkbook Name 1 工作簿路径Workbooks 工作簿 Path 当前活动工作簿的路径ActiveWorkbook Path ThisWorkbook Path 新建工作簿Workbooks Add 打开工作簿Workbooks OpenFilename 路径 UpdateLinks x x为 0 1 2 3 打开工作簿 窗口选择 Workbooks OpenFilename Application GetOpenFilename Excel工作簿 xls xls 工作簿是否打开NotApplication Workbooks 工作簿名 IsNothing True 工作簿打开方式Workbooks 1 ReadOnly True Workbooks 1 ReadOnly False 打开的工作簿数Workbooks Count 打开最近使用过的文件Application RecentFiles n Open 保存工作簿Workbooks 工作簿 Save 另存工作簿并设密码ThisWorkbook SaveAsFilename 路径 WriteResPassword 密码 另存工作簿 窗口选择 ThisWorkbook SaveAsFilename Application GetSaveAsFilename Excel工作簿 xls xls 指定工作簿的副本保存到文件ThisWorkbook SaveCopyAsFilename 路径 保存自动恢复文件WithApplication AutoRecover Time 分钟 Path 路径 EndWith 当前工作薄文件添加到收藏中ActiveWorkbook AddToFavorites 工作簿是否保存Workbooks 工作簿名 Saved True False 工作簿最后保存时间Workbooks 工作簿名 BuiltinDocumentProperties LastSaveTime 关闭工作簿ThisWorkbook Closesavechanges False 关闭所以工作簿Workbooks Close 保护撤消工作薄Workbooks 1 ProtectPassword Structure True Windows True Workbooks 1 UnprotectPassword 窗格冻结ActiveWindow FreezePanes True False 结构窗口保护Workbooks 1 ProtectStructure True Workbooks 1 ProtectWindows True 窗口的标题ActiveWindow Caption Windows 1 Caption Application Windows 1 Caption 窗口拆分ActiveWindow Split True False ActiveWindow SplitColumn 1 ActiveWindow SplitRow 1 ActiveWindow SplitHorizontal ActiveWindow SplitVertical 窗口切换ActiveWindow ActivateNext ActiveWindow ActivatePrevious 窗口隐藏ActiveWindow Visible False True 新建窗口ActiveWindow NewWindow Windows ArrangeArrangestyle xlArrangeStyleVertical ActiveWindow WindowState xlMaximized 重排窗口Windows ArrangeActiveWorkbook True Windows ArrangeArrangestyle x x为 xlArrangeStyleTiled xlArrangeStyleCascade xlArrangeStyleHorizontal xlArrangeStyleVertical 显示比例ActiveWindow Zoom 200 ActiveWindow Zoom 100 设置工作簿视图选项ActiveWindow DisplayFormulas False ActiveWindow DisplayGridlines False ActiveWindow DisplayHeadings False ActiveWindow DisplayOutline False ActiveWindow DisplayZeros False ActiveWindow DisplayHorizontalScrollBar False ActiveWindow DisplayVerticalScrollBar False ActiveWindow DisplayWorkbookTabs False 设置网格线颜色ActiveWindow GridlineColorIndex n ActiveWindow GridlineColorIndex xlColorIndexAutomatic 判断工作簿是否加载宏Workbooks 1 IsAddin True False Left ThisWorkbook Name InStr ThisWorkbook Name 1 Workbooks OpenFilename 路径 UpdateLinks x Workbooks OpenFilename Application GetOpenFilename Excel工作簿 xls xls NotApplication Workbooks 工作簿名 IsNothing True ThisWorkbook SaveAsFilename 路径 WriteResPassword 密码 ThisWorkbook SaveAsFilename Application GetSaveAsFilename Excel工作簿 xls xls ThisWorkbook SaveCopyAsFilename 路径 Workbooks 工作簿名 Saved True False Workbooks 工作簿名 BuiltinDocumentProperties LastSaveTime ThisWorkbook Closesavechanges False Workbooks 1 ProtectPassword Structure True Windows True Workbooks 1 UnprotectPassword ActiveWindow FreezePanes True False Windows ArrangeArrangestyle xlArrangeStyleVertical ActiveWindow WindowState xlMaximized Windows ArrangeActiveWorkbook True ActiveWindow DisplayGridlines False ActiveWindow DisplayHorizontalScrollBar False ActiveWindow DisplayVerticalScrollBar False ActiveWindow DisplayWorkbookTabs False ActiveWindow GridlineColorIndex xlColorIndexAutomatic 第3章Worksheet 工作表 对象 判断是否是工作表Sheets 1 Type xlWorksheet 当前活动工作表名ActiveSheet Name 工作表数Worksheets Count 激活工作表Sheets 1 Activate 选取工作表Sheets 1 Select 新建工作表Worksheets Add Worksheets AddCount n Worksheets Addafter Sheets 1 Worksheets Addbefore Sheets 1 复制工作表Sheets 1 Copy Sheets 1 CopyAfter Sheets 1 Sheets 1 CopyBefore Sheets 1 移动工作表Sheets 1 Move Sheets 1 MoveAfter Sheets 2 Sheets 1 MoveBefore Sheets 3 删除工作表Sheets 1 Delete 隐藏显示工作表Sheets 1 Visible False True Sheets 1 Visible xlSheetHidden xlSheetVisible Sheets 1 Visible xlSheetVeryHidden xlSheetVisible Sheets 1 Visible 1 2 保护工作表WithSheets 1 ProtectPassword ProtectContents True ProtectDrawingObjects True ProtectScenarios True ProtectAllowDeletingColumns True ProtectAllowDeletingRows True ProtectAllowFiltering True ProtectAllowFormattingCells True ProtectAllowFormattingColumns True ProtectAllowFormattingRows True ProtectAllowInsertingColumns True ProtectAllowInsertingRows True ProtectAllowInsertingHyperlinks True ProtectAllowSorting True EnableSelection xlNoSelection EnableSelection xlNoRestrictions EnableSelection xlUnlockedCells 撤消工作表保护Sheets 1 UnprotectPassword 自动筛选设置数据范围 AutoFilterField n Criteria1 字符 VisibleDropDown True False 工作表处于筛选模式Sheets 1 FilterMode True False 取消自动筛选Sheets 1 AutoFilterMode False 显示所有数据 同下拉列 菜单全部 Sheets 1 ShowAllData 重算工作表Sheets 1 EnableCalculation True Sheets 1 EnableCalculation False 显示所有工作标签CommandBars WorkbookTabs ShowPopup 更改工作表表签颜色Sheets 1 Tab ColorIndex n n为 1 2 3 4 5 6 7 8 9 xlColorIndexNone 数据范围 AutoFilterField n Criteria1 字符 VisibleDropDown True False 第4章Range 单元格 对象 选取单元格 A1 Select A1 D8 Select A1 D8 A20 C25 F6 G10 Select A A Select A D Select A A C C H H Select 1 1 Select 5 20 Select 1 1 3 3 5 5 Select Cells Select 选取与某值不同的单元格Sheets 1 Columns A ColumnDifferences Comparison Sheets 1 A1 Select 合并单元格区域Union Range A1 B10 Range D1 E10 Range G1 G10 Range Range A1 B10 Range D1 E10 Range G1 G10 活动单元格ActiveCell 已用的单元格ActiveSheet UsedRange 空行围成的单元格 a1 CurrentRegion Rows Cells 可视单元格区域ActiveWindow VisibleRange 公式引用的单元格 a1 Precedents Application Evaluate a1 Formula 从属单元格 a1 Dependents 特殊单元格选取Activesheet cells SpecialCells x y Select x为 xlCellTypeAllFormatConditions xlCellTypeAllValidation xlCellTypeBlanks xlCellTypeComments xlCellTypeLastCell xlCellTypeVisible可见 xlCellTypeSameFormatConditions xlCellTypeSameValidation xlCellTypeConstants xlCellTypeFormulas 当x为xlCellTypeConstants或xlCellTypeFormulas时y为 xlError xlLogical xlNumbers xlTextValues 偏移单元格 a1 Offset x y 调整单元格Resize x y 单元格总数Sheet 1 Cells Count A列最后非空一行Range A65536 End xlUp Row 第一行最后非空一列Range IV1 End xlToLeft Column 隐藏行列 a1 EntireRow Hidden True False a1 EntireColumn Hidden True False Rows 1 Hidden True False Columns 1 Hidden True False Rows Hidden True False Cells Rows Hidden True False Columns Hidden True False 设置行高列宽 A1 RowHeight n A1 ColumnWidth n 设置列宽行高 厘米 Application CentimetersToPoints 1 Application CentimetersToPoints 2 设置列宽行高 英寸 Application InchesToPoints 1 Application InchesToPoints 0 5 自动调整单元格 A1 EntireColumn AutoFit A1 EntireRow AutoFit 设置滚动区域Sheets 1 ScrollArea a1 Sheets 1 ScrollArea 输入公式 a1 Formula TODAY 是否有公式单元格 a1 HasFormula True False 是否有数组公式单元格 a1 HasArray True False 设置为数组公式 A1 FormulaArray 数组公式 单元格引用样式 A1 Address A1 Address False False A1 Address RowAbsolute False A1 Address ColumnAbsolute False A1 Address ReferenceStyle xlR1C1 A1 Address False False ReferenceStyle xlR1C1 A1 Address RowAbsolute False ReferenceStyle xlR1C1 A1 Address ColumnAbsolute False ReferenceStyle xlR1C1 单元格剪切 A1 CutDestination b1 单元格复制 A1 CopyDestination b1 A1 Copy b1 将单元格复制成图片 A1 CopyPicturexlScreen xlBitmap B1 Select B1 Parent Pictures Paste 选择性粘贴 A1 Copy B1 PasteSpecialPaste x Operation y SkipBlanks True False Transpose True False x为 xlPasteAll xlPasteAllExceptBorders xlPasteColumnWidths xlPasteComments xlPasteFormats xlPasteFormulas xlPasteFormulasAndNumberFormats xlPasteValidation xlPasteValues xlPasteValuesAndNumberFormats y为 xlPasteSpecialOperationNone xlPasteSpecialOperationAdd xlPasteSpecialOperationSubtract xlPasteSpecialOperationMultiply xlPasteSpecialOperationDivide 插入行列 A1 InsertShift xlToRight A1 InsertShift xlDown A1 EntireRow InsertShift xlShiftDown A1 EntireColumn InsertShift xlShiftToRight 删除行列 A1 DeleteShift xlUp A1 DeleteShift xlToLeft A1 EntireRow DeleteShift xlUp A1 EntireColumn DeleteShift xlToLeft 清除单元格 A1 ClearFormats A1 ClearContents A1 ClearComments A1 ClearNotes A1 Clear 拼音指南 a1 拼音 a1 Characters 1 3 PhoneticCharacters pinyin a1 Phonetic Visible True 批注设置With a1 Comment Delete AddComment Text 批注内容 Comment Visible False Comment TextText 插入内容 Start 1 EndWith a1 NoteText 超链接设置Sheets 1 Hyperlinks Delete Sheets 1 Hyperlinks AddAnchor a1 Address Sheets 1 Hyperlinks AddAnchor a1 Address 路径 ScreenTip 屏幕文字提示 数据有效性设置 a1 Validation AddType x AlertStyle xlValidAlertStop Operator y Formula1 100 x为 xlValidateWholeNumber xlValidateDecimal xlValidateDate xlValidateTime xlValidateTextLength xlValidateList y xlEqual Formula1 1 2 3 4 5 6 7 8 9 10 11 12 y xlBetween Formula1 D 1 D 10 y为 xlBetween后面加 Formul2 1000 xlGreater xlLess xlGreaterEqual xlLessEqual xlNotEqual xlEqual IgnoreBlank True InCellDropdown True InputTitle 整数 ErrorTitle 数据错误 InputMessage 请输入整数 ErrorMessage 数据超出了范围 IMEMode xlIMEModeOff ShowInput True ShowError True 单元格填充设置 A1 A20 Cells 1 Value x A1 A20 Cells 1 AutoFillDestination A1 A20 Type y y为 xlFillDaysx为日期型 xlFillFormats xlFillSeriesx为数值 公式 xlFillWeekdaysx为日期型 xlGrowthTrend xlFillCopy xlFillDefault xlFillMonthsx为日期型 xlFillValuesx为数值 公式 xlFillYearsx为日期型 xlLinearTrend 单元格数字设置 a1 NumberFormatLocal x x为 G 通用格式 0 0 00 红色 0 00 yyyy m d h mm ss 0 0 0E 0 DBNum1 804 G 通用格式 DBNum2 804 G 通用格式 单元格对齐设置 A1 HorizontalAlignment x x为 xlHAlignLeft xlHAlignRight xlHAlignCenter xlHAlignFill xlHAlignCenterAcrossSelection xlHAlignDistributed xlHAlignGeneral xlHAlignJustify A1 VerticalAlignment x x为 xlVAlignCenter xlVAlignJustify xlVAlignBottom xlVAlignDistributed xlVAlignTop A1 Orientation 0 360 A1 AddIndent True A1 WrapText True A1 ShrinkToFit True a1 a2 Merge a1 a2 UnMerge a1 MergeCells True 单元格字体设置 a1 Font Name字体名称 VALUE a1 Font Size n a1 Font ColorIndex n a1 Font Underline x x为 xlUnderlineStyleNone xlUnderlineStyleSingle xlUnderlineStyleDouble xlUnderlineStyleSingleAccounting xlUnderlineStyleDoubleAccounting a1 Font Strikethrough True False a1 Font Subscript True False a1 Font Superscript True False 单元格边框设置 a1 Borders x ColorIndex n a1 Borders x LineStyle y a1 Borders x Weight z x为 xlEdgeTop xlEdgeBottom xlEdgeLeft xlEdgeRight xlDiagonalDown xlDiagonalUp xlInsideHorizontal xlInsideVertical y为 xlContinuous xlDouble xlDash xlDashDot xlDashDotDot xlDot xlSlantDashDot xlLineStyleNone z为 xlHairline xlThin xlMedium xlThick 单元格图案设置 a1 Interior ColorIndex n a1 Interior Pattern n a1 Interior PatternColorIndex n 单元格保护设置 a1 Locked True False a1 FormulaHidden True False Sheets 1 Columns A ColumnDifferences Comparison Sheets 1 A1 Select B1 PasteSpecialPaste x Operation y SkipBlanks True False Transpose True False Sheets 1 Hyperlinks AddAnchor a1 Address 路径 ScreenTip 屏幕文字提示 第5章Chart 图表 对象 图表属性WithSheets 1 ChartObjects 1 Name Left Top Height Width Chart ChartType 返回值 xlLine xlLineMarkersStacked xlLineStacked xlPie xlPieOfPie xlPyramidBarStacked xlPyramidCol xlPyramidColClustered xlPyramidColStacked xlPyramidColStacked100 xlRadar xlRadarFilled xlRadarMarkers xlStockHLC xlStockOHLC xlStockVHLC xlStockVOHLC xlSurface xlSurfaceTopView xlSurfaceTopViewWireframe xlSurfaceWireframe xlXYScatter xlXYScatterLines xlXYScatterLinesNoMarkers xlXYScatterSmooth xlXYScatterSmoothNoMarkers xl3DArea xl3DAreaStacked xl3DAreaStacked100 xl3DBarClustered xl3DBarStacked xl3DBarStacked100 xl3DColumn xl3DColumnClustered xl3DColumnStacked xl3DColumnStacked100 xl3DLine xl3DPie xl3DPieExploded xlArea xlAreaStacked xlAreaStacked100 xlBarClustered xlBarOfPie xlBarStacked xlBarStacked100 xlBubble xlBubble3DEffect xlColumnClustered xlColumnStacked xlColumnStacked100 xlConeBarClustered xlConeBarStacked xlConeBarStacked100 xlConeCol xlConeColClustered xlConeColStacked xlConeColStacked100 xlCylinderBarClustered xlCylinderBarStacked xlCylinderBarStacked100 xlCylinderCol xlCylinderColClustered xlCylinderColStacked xlCylinderColStacked100 xlDoughnut xlDoughnutExploded xlLineMarkers xlLineMarkersStacked100 xlLineStacked100 xlPieExploded xlPyramidBarClustered xlPyramidBarStacked100 图表标题属性WithSheets 1 ChartObjects 1 Chart HasTitle True With ChartTitle Name Text Font Name Font Size Font ColorIndex Interior ColorIndex Left Top EndWith EndWith 图表图例属性WithSheets 1 ChartObjects 1 Chart HasLegend True With Legend Name Font Name Font Size Font ColorIndex Interior ColorIndex Left Top EndWith EndWith 坐标轴属性WithSheets 1 ChartObjects 1 Chart Axes x x为 xlValue xlCategory HasTitle True AxisTitle Text MinimumScale MaximumScale With TickLabels Font Name Size EndWith EndWith 趋势线属性WithSheets 1 ChartObjects 1 Chart SeriesCollection 1 Trendlines 1 Type 返回值 xlExponential xlLinear xlLogarithmic xlMovingAvg xlPolynomial xlPower DisplayRSquared True DisplayEquation True DataLabel Text 绘图区属性WithSheets 1 ChartObjects 1 Chart PlotArea Height Width Interior ColorIndex With Border LineStyle Weight ColorIndex EndWith With Font Name Size ColorIndex EndWith 创建图表WithCharts Add ChartType 图表类型 SetSourceDataSource 数据源 PlotBy xlRows xlColumns With SeriesCollection 1 XValues 数据源 Values 数据源 Name 图表名称 ApplyDataLabelsAutoText True ShowValue True EndWith LocationWhere xlLocationAsObject Name 图表名称 EndWith 图表另存为图片WithSheets 1 ChartObjects 1 Chart ExportFilename 路径 名称 jpg Filtername JPG EndWith 图表添加入批注WithSheets 1 a1 AddComment Shape Height n Width n Fill UserPicture路径 名称 jpg EndWith Sheets 1 a1 Comment Visible False 插入图表WithSheets 1 Pictures Insert路径 名称 jpg Left n Top n EndWith WithSheets 1 ChartObjects 1 Chart SeriesCollection 1 Trendlines 1 SetSourceDataSource 数据源 PlotBy xlRows xlColumns LocationWhere xlLocationAsObject Name 图表名称 ExportFilename 路径 名称 jpg Filtername JPG 第6章Shape 图形 对象 图形属性WithSheets 1 Shapes 1 Name Type 返回值 msoShapeTypeMixed msoAutoShape msoCallout msoChart msoComment msoFreeform msoGroup msoFormControl msoLine msoLinke