VBA内置对话框参数表

1、对话框常量xlDialogActivatexlDialogActiveCellFontxlDialogAddChartAutoformatxlDialogAddinManagerxlDialogAlignmentxlDialogApplyNamesxlDialogApplyStylexlDialogAppMovexlDialogAppSizexlDialogArrangeAllxlDialogAssignToObjectxlDialogAssignToToolxlDialogAttachTextxlDialogAttachToolbarsxlDialogAutoCorrectxlDialogA

2、xesxlDialogAxesxlDialogBorderxlDialogCalculationxlDialogCellProtectionxlDialogChangeLink内置对话框参数表参数表window_text,pane_numfont,font_style,size,strikethrough,superscript,subscript,outline,shadow,underline,color,normal,background,start_char,char_countname_text,desc_textoperation_num,addinname_text,copy_l

3、ogicalhoriz_align,wrap,vert_align,orientation,add_indentname_array,ignore,use_rowcol,omit_col,omit_row,order_num,append_laststyle_textx_num,y_numx_num,y_numarrange_num,active_doc,sync_horiz,sync_vertmacro_refbar_id,position,macro_refattach_to_num,series_num,point_numcorrect_initial_caps,capitalize_d

4、aysx_primary,y_primary,x_secondary,y_secondaryx_primary,y_primary,z_primaryoutline,left,right,top,bottom,shade,outline_color,left_color,right_color,top_color,bottom_colortype_num,iter,max_num,max_change,update,precision,date_1904,calc_save,save_values,alt_exp,alt_formlocked,hiddenold_text,new_text,t

5、ype_of_linkxlDialogChartAddDataxlDialogChartLocationxlDialogChartOptionsDataLabelsxlDialogChartOptionsDataTablexlDialogChartSourceDataxlDialogChartTrendxlDialogChartTypexlDialogChartWizardxlDialogCheckboxPropertiesxlDialogClearxlDialogColorPalettexlDialogColumnWidthxlDialogCombinationxlDialogConditi

6、onalFormattingxlDialogConsolidatexlDialogCopyChartxlDialogCopyPicturexlDialogCreateNamesxlDialogCreatePublisherxlDialogCustomizeToolbarxlDialogCustomViewsxlDialogDataDeletexlDialogDataLabelxlDialogDataSeriesxlDialogDataValidationxlDialogDefineNameref,rowcol,titles,categories,replace,seriestype,ord_p

7、er,forecast,backcast,intercept,equation,r_squared,namelong,ref,gallery_num,type_num,plot_by,categories,ser_titles,legend,title,x_title,y_title,z_title,number_cats,number_titlesvalue,link,accel_text,accel2_text,3d_shadingtype_numfile_textwidth_num,reference,standard,type_num,standard_numtype_numsourc

8、e_refs,function_num,top_row,left_col,create_linkssize_numappearance_num,size_num,type_numtop,left,bottom,rightfile_text,appearance,size,formatscategoryshow_option,auto_text,show_keyrowcol,type_num,date_num,step_value,stop_value,trendname_text,refers_to,macro_type,shortcut_text,hidden,xlDialogDefineS

9、tylexlDialogDefineStylexlDialogDeleteFormatxlDialogDeleteNamexlDialogDemotexlDialogDisplayxlDialogDisplayxlDialogEditboxPropertiesxlDialogEditColorxlDialogEditDeletexlDialogEditionOptionsxlDialogEditSeriesxlDialogErrorbarXxlDialogErrorbarYxlDialogExternalDataPropertiesxlDialogExtractxlDialogFileDele

10、texlDialogFileSharingxlDialogFillGroupxlDialogFillWorkgroupxlDialogFilterxlDialogFilterAdvancedxlDialogFindFilexlDialogFontcategory,localstyle_text,number,font,alignment,border,pattern,protectionstyle_text,attribute_num,additional_def_args,.format_textname_textrow_colformulas,gridlines,headings,zero

11、s,color_num,reserved,outline,page_breaks,object_numcell,formula,value,format,protection,names,precedents,dependents,notevalidation_num,multiline_logical,vscroll_logical,password_logicalcolor_num,red_value,green_value,blue_valueshift_numedition_type,edition_name,reference,option,appearance,size,forma

12、tsseries_num,name_ref,x_ref,y_ref,z_ref,plot_orderinclude,type,amount,minusinclude,type,amount,minusuniquefile_texttype_numtype_numoperation,list_ref,criteria_ref,copy_ref,uniquename_text,size_numxlDialogFontPropertiesxlDialogFormatAutoxlDialogFormatChartxlDialogFormatCharttypexlDialogFormatFontxlDi

13、alogFormatFontxlDialogFormatFontxlDialogFormatLegendxlDialogFormatMainxlDialogFormatMovexlDialogFormatMovexlDialogFormatMovexlDialogFormatNumberxlDialogFormatOverlayxlDialogFormatSizexlDialogFormatSizexlDialogFormatTextxlDialogFormulaFindxlDialogFormulaGotofont,font_style,size,strikethrough,superscr

14、ipt,subscript,outline,shadow,underline,color,normal,background,start_char,char_countformat_num,number,font,alignment,border,pattern,widthlayer_num,view,overlap,angle,gap_width,gap_depth,chart_depth,doughnut_size,axis_num,drop,hilo,up_down,series_line,labels,varyapply_to,group_num,dimension,type_numc

15、olor,backgd,apply,name_text,size_num,bold,italic,underline,strike,outline,shadow,object_id,start_num,char_numname_text,size_num,bold,italic,underline,strike,color,outline,shadowname_text,size_num,bold,italic,underline,strike,color,outline,shadow,object_id_text,start_num,char_numposition_numtype_num,

16、view,overlap,gap_width,vary,drop,hilo,angle,gap_depth,chart_depth,up_down,series_line,labels,doughnut_sizex_offset,y_offset,referencex_pos,y_posexplosion_numformat_texttype_num,view,overlap,gap_width,vary,drop,hilo,angle,series_dist,series_num,up_down,series_line,labels,doughnut_sizewidth,heightx_of

17、f,y_off,referencex_align,y_align,orient_num,auto_text,auto_size,show_key,show_value,add_indenttext,in_num,at_num,by_num,dir_num,match_case,match_bytereference,cornerxlDialogFormulaReplacexlDialogFunctionWizardxlDialogGallery3dAreaxlDialogGallery3dBarxlDialogGallery3dColumnxlDialogGallery3dLinexlDial

18、ogGallery3dPiexlDialogGallery3dSurfacexlDialogGalleryAreaxlDialogGalleryBarxlDialogGalleryColumnxlDialogGalleryCustomxlDialogGalleryDoughnutxlDialogGalleryLinexlDialogGalleryPiexlDialogGalleryRadarxlDialogGalleryScatterxlDialogGoalSeekxlDialogGridlinesxlDialogImportTextFilexlDialogInsertxlDialogInse

19、rtHyperlinkxlDialogInsertNameLabelxlDialogInsertObjectxlDialogInsertPicturexlDialogInsertTitlefind_text,replace_text,look_at,look_by,active_cell,match_case,match_bytetype_numtype_numtype_numtype_numtype_numtype_numtype_num,delete_overlaytype_num,delete_overlaytype_num,delete_overlayname_texttype_num

20、,delete_overlaytype_num,delete_overlaytype_num,delete_overlaytype_num,delete_overlaytype_num,delete_overlaytarget_cell,target_value,variable_cellx_major,x_minor,y_major,y_minor,z_major,z_minor,2D_effectshift_numobject_class,file_name,link_logical,display_icon_logical,icon_file,icon_number,icon_label

21、file_name,filter_numberchart,y_primary,x_primary,y_secondary,x_secondaryxlDialogLabelPropertiesxlDialogListboxPropertiesxlDialogMacroOptionsxlDialogMailEditMailerxlDialogMailLogonxlDialogMailNextLetterxlDialogMainChartxlDialogMainChartTypexlDialogMenuEditorxlDialogMovexlDialogNewxlDialogNewWebQueryx

22、lDialogNotexlDialogObjectPropertiesxlDialogObjectProtectionxlDialogOpenxlDialogOpenLinksxlDialogOpenMailxlDialogOpenTextxlDialogOptionsCalculationxlDialogOptionsChartxlDialogOptionsEditaccel_text,accel2_text,3d_shadingrange,link,drop_size,multi_select,3d_shadingmacro_name,description,menu_on,menu_te

23、xt,shortcut_on,shortcut_key,function_category,status_bar_text,help_id,help_fileto_recipients,cc_recipients,bcc_recipients,subject,enclosures,which_addressname_text,password_text,download_logicaltype_num,stack,100,vary,overlap,drop,hilo,overlap%,cluster,angletype_numx_pos,y_pos,window_texttype_num,xy

24、_series,add_logicaladd_text,cell_ref,start_char,num_charsplacement_type,print_objectlocked,lock_textfile_text,update_links,read_only,format,prot_pwd,write_res_pwd,ignore_rorec,file_origin,custom_delimit,add_logical,editable,file_access,notify_logical,converterdocument_text1,document_text2,.,read_onl

25、y,type_of_linksubject,commentsfile_name,file_origin,start_row,file_type,text_qualifier,consecutive_delim,tab,semicolon,comma,space,other,other_char,field_infotype_num,iter,max_num,max_change,update,precision,date_1904,calc_save,save_valuesdisplay_blanks,plot_visible,size_with_windowincell_edit,drag_

26、drop,alert,entermove,fixed,decimals,copy_objects,update_links,move_direction,autocomplete,animationsxlDialogOptionsGeneralxlDialogOptionsListsAddxlDialogOptionsListsAddxlDialogOptionsMExlDialogOptionsTransitionxlDialogOptionsViewxlDialogOutlinexlDialogOverlayxlDialogOverlayChartTypexlDialogPageSetup

27、xlDialogPageSetupxlDialogPageSetupxlDialogParsexlDialogPasteNamesxlDialogPasteSpecialxlDialogPasteSpecialxlDialogPasteSpecialxlDialogPasteSpecialxlDialogPatternsR1C1_mode,dde_on,sum_info,tips,recent_files,old_menus,user_info,font_name,font_size,default_location,alternate_location,sheet_num,enable_un

28、derstring_arrayimport_ref,by_rowdef_rtl_sheet,crsr_mvmt,show_ctrl_char,gui_langmenu_key,menu_key_action,nav_keys,trans_eval,trans_entryformula,status,notes,show_info,object_num,page_breaks,formulas,gridlines,color_num,headers,outline,zeros,hor_scroll,vert_scroll,sheet_tabsauto_styles,row_dir,col_dir

29、,create_applytype_num,stack,100,vary,overlap,drop,hilo,overlap%,cluster,angle,series_num,autotype_numhead,foot,left,right,top,bot,hdng,grid,h_cntr,v_cntr,orient,paper_size,scale,pg_num,pg_order,bw_cells,quality,head_margin,foot_margin,notes,drafthead,foot,left,right,top,bot,size,h_cntr,v_cntr,orient

30、,paper_size,scale,pg_num,bw_chart,quality,head_margin,foot_margin,drafthead,foot,left,right,top,bot,orient,paper_size,scale,quality,head_margin,foot_margin,pg_numparse_text,destination_refpaste_num,operation_num,skip_blanks,transposerowcol,titles,categories,replace,seriespaste_numformat_text,pasteli

31、nk_logical,display_icon_logical,icon_file,icon_number,icon_labelapattern,afore,aback,newuixlDialogPatternsxlDialogPatternsxlDialogPatternsxlDialogPatternsxlDialogPatternsxlDialogPatternsxlDialogPatternsxlDialogPhoneticxlDialogPivotCalculatedFieldxlDialogPivotCalculatedItemxlDialogPivotClientServerSe

32、txlDialogPivotFieldGroupxlDialogPivotFieldPropertiesxlDialogPivotFieldUngroupxlDialogPivotShowPagesxlDialogPivotSolveOrderxlDialogPivotTableOptionsxlDialogPivotTableWizardxlDialogPlacementxlDialogPrintxlDialogPrinterSetupxlDialogPrintPreviewlauto,lstyle,lcolor,lwt,hwidth,hlength,htypebauto,bstyle,bc

33、olor,bwt,shadow,aauto,apattern,afore,aback,rounded,newuibauto,bstyle,bcolor,bwt,shadow,aauto,apattern,afore,aback,invert,apply,newfilllauto,lstyle,lcolor,lwt,tmajor,tminor,tlabellauto,lstyle,lcolor,lwt,apply,smoothlauto,lstyle,lcolor,lwt,mauto,mstyle,mfore,mback,apply,smoothtype,picture_units,applys

34、tart,end,by,periodsname,pivot_field_name,new_name,orientation,function,formatsname,page_fieldtype,source,destination,name,row_grand,col_grand,save_data,apply_auto_format,auto_page,reservedplacement_typerange_num,from,to,copies,draft,preview,print_what,color,feed,quality,y_resolution,selection,printe

35、r_text,print_to_file,collateprinter_textxlDialogPromotexlDialogPropertiesxlDialogProtectDocumentxlDialogProtectSharingxlDialogPublishAsWebPagexlDialogPushbuttonPropertiesxlDialogReplaceFontxlDialogRoutingSlipxlDialogRowHeightxlDialogRunxlDialogSaveAsxlDialogSaveCopyAsxlDialogSaveNewObjectxlDialogSav

36、eWorkbookxlDialogSaveWorkspacexlDialogScalexlDialogScalexlDialogScalexlDialogScalexlDialogScalexlDialogScenarioAddxlDialogScenarioCellsxlDialogScenarioEditrowcoltitle,subject,author,keywords,commentscontents,windows,password,objects,scenariosdefault_logical,cancel_logical,dismiss_logical,help_logica

37、l,accel_text,accel_text2font_num,name_text,size_num,bold,italic,underline,strike,color,outline,shadowrecipients,subject,message,route_num,return_logical,status_logicalheight_num,reference,standard_height,type_numreference,stepdocument_text,type_num,prot_pwd,backup,write_res_pwd,read_only_recdocument

38、_textdocument_text,type_num,prot_pwd,backup,write_res_pwd,read_only_recname_textcross,cat_labels,cat_marks,between,max,reversemin_num,max_num,major,minor,cross,logarithmic,reverse,maxcat_labels,cat_marks,reverse,betweenseries_labels,series_marks,reversemin_num,max_num,major,minor,cross,logarithmic,r

39、everse,minscen_name,value_array,changing_ref,scen_comment,locked,hiddenchanging_refscen_name,new_scenname,value_array,changing_ref,xlDialogScenarioMergexlDialogScenarioSummaryxlDialogScrollbarPropertiesxlDialogSelectSpecialxlDialogSendMailxlDialogSeriesAxesxlDialogSeriesOptionsxlDialogSeriesOrderxlD

40、ialogSeriesShapexlDialogSeriesXxlDialogSeriesYxlDialogSetBackgroundPicturexlDialogSetPrintTitlesxlDialogSetUpdateStatusxlDialogShowDetailxlDialogShowToolbarxlDialogSizexlDialogSortxlDialogSortxlDialogSortSpecialxlDialogSplitxlDialogStandardFontxlDialogStandardWidthxlDialogStylescen_comment,locked,hi

41、ddensource_fileresult_ref,report_typevalue,min,max,inc,page,link,3d_shadingtype_num,value_type,levelsrecipients,subject,return_receiptaxis_numchart_num,old_series_num,new_series_numx_refname_ref,y_reftitles_for_cols_ref,titles_for_rows_reflink_text,status,type_of_linkrowcol,rowcol_num,expand,show_fi

42、eldbar_id,visible,dock,x_pos,y_pos,width,protect,tool_tips,large_buttons,color_buttonswidth,height,window_textorientation,key1,order1,key2,order2,key3,order3,header,custom,caseorientation,key1,order1,type,customsort_by,method,key1,order1,key2,order2,key3,order3,header,order,casecol_split,row_splitname_text,size_num,bold,italic,underline,strike,color,ou