Export (0) Print
Expand All

Built-In Dialog Box Argument Lists

Office 2007
Dialog box constantArgument list(s)
xlDialogActivatewindow_text, pane_num
xlDialogActiveCellFontfont, font_style, size, strikethrough, superscript, subscript, outline, shadow, underline, color, normal, background, start_char, char_count
xlDialogAddChartAutoformatname_text, desc_text
xlDialogAddinManageroperation_num, addinname_text, copy_logical
xlDialogAlignmenthoriz_align, wrap, vert_align, orientation, add_indent
xlDialogApplyNamesname_array, ignore, use_rowcol, omit_col, omit_row, order_num, append_last
xlDialogApplyStylestyle_text
xlDialogAppMovex_num, y_num
xlDialogAppSizex_num, y_num
xlDialogArrangeAllarrange_num, active_doc, sync_horiz, sync_vert
xlDialogAssignToObjectmacro_ref
xlDialogAssignToToolbar_id, position, macro_ref
xlDialogAttachTextattach_to_num, series_num, point_num
xlDialogAttachToolbars
xlDialogAutoCorrectcorrect_initial_caps, capitalize_days
xlDialogAxesx_primary, y_primary, x_secondary, y_secondary
xlDialogAxesx_primary, y_primary, z_primary
xlDialogBorderoutline, left, right, top, bottom, shade, outline_color, left_color, right_color, top_color, bottom_color
xlDialogCalculationtype_num, iter, max_num, max_change, update, precision, date_1904, calc_save, save_values, alt_exp, alt_form
xlDialogCellProtectionlocked, hidden
xlDialogChangeLinkold_text, new_text, type_of_link
xlDialogChartAddDataref, rowcol, titles, categories, replace, series
xlDialogChartLocation
xlDialogChartOptionsDataLabels
xlDialogChartOptionsDataTable
xlDialogChartSourceData
xlDialogChartTrendtype, ord_per, forecast, backcast, intercept, equation, r_squared, name
xlDialogChartType
xlDialogChartWizardlong, ref, gallery_num, type_num, plot_by, categories, ser_titles, legend, title, x_title, y_title, z_title, number_cats, number_titles
xlDialogCheckboxPropertiesvalue, link, accel_text, accel2_text, 3d_shading
xlDialogCleartype_num
xlDialogColorPalettefile_text
xlDialogColumnWidthwidth_num, reference, standard, type_num, standard_num
xlDialogCombinationtype_num
xlDialogConditionalFormatting
xlDialogConsolidatesource_refs, function_num, top_row, left_col, create_links
xlDialogCopyChartsize_num
xlDialogCopyPictureappearance_num, size_num, type_num
xlDialogCreateNamestop, left, bottom, right
xlDialogCreatePublisherfile_text, appearance, size, formats
xlDialogCustomizeToolbarcategory
xlDialogCustomViews
xlDialogDataDelete
xlDialogDataLabelshow_option, auto_text, show_key
xlDialogDataSeriesrowcol, type_num, date_num, step_value, stop_value, trend
xlDialogDataValidation
xlDialogDefineNamename_text, refers_to, macro_type, shortcut_text, hidden, category, local
xlDialogDefineStylestyle_text, number, font, alignment, border, pattern, protection
xlDialogDefineStylestyle_text, attribute_num, additional_def_args, ...
xlDialogDeleteFormatformat_text
xlDialogDeleteNamename_text
xlDialogDemoterow_col
xlDialogDisplayformulas, gridlines, headings, zeros, color_num, reserved, outline, page_breaks, object_num
xlDialogDisplaycell, formula, value, format, protection, names, precedents, dependents, note
xlDialogEditboxPropertiesvalidation_num, multiline_logical, vscroll_logical, password_logical
xlDialogEditColorcolor_num, red_value, green_value, blue_value
xlDialogEditDeleteshift_num
xlDialogEditionOptionsedition_type, edition_name, reference, option, appearance, size, formats
xlDialogEditSeriesseries_num, name_ref, x_ref, y_ref, z_ref, plot_order
xlDialogErrorbarXinclude, type, amount, minus
xlDialogErrorbarYinclude, type, amount, minus
xlDialogExternalDataProperties
xlDialogExtractunique
xlDialogFileDeletefile_text
xlDialogFileSharing
xlDialogFillGrouptype_num
xlDialogFillWorkgrouptype_num
xlDialogFilter
xlDialogFilterAdvancedoperation, list_ref, criteria_ref, copy_ref, unique
xlDialogFindFile
xlDialogFontname_text, size_num
xlDialogFontPropertiesfont, font_style, size, strikethrough, superscript, subscript, outline, shadow, underline, color, normal, background, start_char, char_count
xlDialogFormatAutoformat_num, number, font, alignment, border, pattern, width
xlDialogFormatChartlayer_num, view, overlap, angle, gap_width, gap_depth, chart_depth, doughnut_size, axis_num, drop, hilo, up_down, series_line, labels, vary
xlDialogFormatCharttypeapply_to, group_num, dimension, type_num
xlDialogFormatFontcolor, backgd, apply, name_text, size_num, bold, italic, underline, strike, outline, shadow, object_id, start_num, char_num
xlDialogFormatFontname_text, size_num, bold, italic, underline, strike, color, outline, shadow
xlDialogFormatFontname_text, size_num, bold, italic, underline, strike, color, outline, shadow, object_id_text, start_num, char_num
xlDialogFormatLegendposition_num
xlDialogFormatMaintype_num, view, overlap, gap_width, vary, drop, hilo, angle, gap_depth, chart_depth, up_down, series_line, labels, doughnut_size
xlDialogFormatMovex_offset, y_offset, reference
xlDialogFormatMovex_pos, y_pos
xlDialogFormatMoveexplosion_num
xlDialogFormatNumberformat_text
xlDialogFormatOverlaytype_num, view, overlap, gap_width, vary, drop, hilo, angle, series_dist, series_num, up_down, series_line, labels, doughnut_size
xlDialogFormatSizewidth, height
xlDialogFormatSizex_off, y_off, reference
xlDialogFormatTextx_align, y_align, orient_num, auto_text, auto_size, show_key, show_value, add_indent
xlDialogFormulaFindtext, in_num, at_num, by_num, dir_num, match_case, match_byte
xlDialogFormulaGotoreference, corner
xlDialogFormulaReplacefind_text, replace_text, look_at, look_by, active_cell, match_case, match_byte
xlDialogFunctionWizard
xlDialogGallery3dAreatype_num
xlDialogGallery3dBartype_num
xlDialogGallery3dColumntype_num
xlDialogGallery3dLinetype_num
xlDialogGallery3dPietype_num
xlDialogGallery3dSurfacetype_num
xlDialogGalleryAreatype_num, delete_overlay
xlDialogGalleryBartype_num, delete_overlay
xlDialogGalleryColumntype_num, delete_overlay
xlDialogGalleryCustomname_text
xlDialogGalleryDoughnuttype_num, delete_overlay
xlDialogGalleryLinetype_num, delete_overlay
xlDialogGalleryPietype_num, delete_overlay
xlDialogGalleryRadartype_num, delete_overlay
xlDialogGalleryScattertype_num, delete_overlay
xlDialogGoalSeektarget_cell, target_value, variable_cell
xlDialogGridlinesx_major, x_minor, y_major, y_minor, z_major, z_minor, 2D_effect
xlDialogImportTextFile
xlDialogInsertshift_num
xlDialogInsertHyperlink
xlDialogInsertNameLabel
xlDialogInsertObjectobject_class, file_name, link_logical, display_icon_logical, icon_file, icon_number, icon_label
xlDialogInsertPicturefile_name, filter_number
xlDialogInsertTitlechart, y_primary, x_primary, y_secondary, x_secondary
xlDialogLabelPropertiesaccel_text, accel2_text, 3d_shading
xlDialogListboxPropertiesrange, link, drop_size, multi_select, 3d_shading
xlDialogMacroOptionsmacro_name, description, menu_on, menu_text, shortcut_on, shortcut_key, function_category, status_bar_text, help_id, help_file
xlDialogMailEditMailerto_recipients, cc_recipients, bcc_recipients, subject, enclosures, which_address
xlDialogMailLogonname_text, password_text, download_logical
xlDialogMailNextLetter
xlDialogMainCharttype_num, stack, 100, vary, overlap, drop, hilo, overlap%, cluster, angle
xlDialogMainChartTypetype_num
xlDialogMenuEditor
xlDialogMovex_pos, y_pos, window_text
xlDialogNewtype_num, xy_series, add_logical
xlDialogNewWebQuery
xlDialogNoteadd_text, cell_ref, start_char, num_chars
xlDialogObjectPropertiesplacement_type, print_object
xlDialogObjectProtectionlocked, lock_text
xlDialogOpenfile_text, update_links, read_only, format, prot_pwd, write_res_pwd, ignore_rorec, file_origin, custom_delimit, add_logical, editable, file_access, notify_logical, converter
xlDialogOpenLinksdocument_text1, document_text2, ..., read_only, type_of_link
xlDialogOpenMailsubject, comments
xlDialogOpenTextfile_name, file_origin, start_row, file_type, text_qualifier, consecutive_delim, tab, semicolon, comma, space, other, other_char, field_info
xlDialogOptionsCalculationtype_num, iter, max_num, max_change, update, precision, date_1904, calc_save, save_values
xlDialogOptionsChartdisplay_blanks, plot_visible, size_with_window
xlDialogOptionsEditincell_edit, drag_drop, alert, entermove, fixed, decimals, copy_objects, update_links, move_direction, autocomplete, animations
xlDialogOptionsGeneralR1C1_mode, dde_on, sum_info, tips, recent_files, old_menus, user_info, font_name, font_size, default_location, alternate_location, sheet_num, enable_under
xlDialogOptionsListsAddstring_array
xlDialogOptionsListsAddimport_ref, by_row
xlDialogOptionsMEdef_rtl_sheet, crsr_mvmt, show_ctrl_char, gui_lang
xlDialogOptionsTransitionmenu_key, menu_key_action, nav_keys, trans_eval, trans_entry
xlDialogOptionsViewformula, status, notes, show_info, object_num, page_breaks, formulas, gridlines, color_num, headers, outline, zeros, hor_scroll, vert_scroll, sheet_tabs
xlDialogOutlineauto_styles, row_dir, col_dir, create_apply
xlDialogOverlaytype_num, stack, 100, vary, overlap, drop, hilo, overlap%, cluster, angle, series_num, auto
xlDialogOverlayChartTypetype_num
xlDialogPageSetuphead, 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, draft
xlDialogPageSetuphead, foot, left, right, top, bot, size, h_cntr, v_cntr, orient, paper_size, scale, pg_num, bw_chart, quality, head_margin, foot_margin, draft
xlDialogPageSetuphead, foot, left, right, top, bot, orient, paper_size, scale, quality, head_margin, foot_margin, pg_num
xlDialogParseparse_text, destination_ref
xlDialogPasteNames
xlDialogPasteSpecialpaste_num, operation_num, skip_blanks, transpose
xlDialogPasteSpecialrowcol, titles, categories, replace, series
xlDialogPasteSpecialpaste_num
xlDialogPasteSpecialformat_text, pastelink_logical, display_icon_logical, icon_file, icon_number, icon_label
xlDialogPatternsapattern, afore, aback, newui
xlDialogPatternslauto, lstyle, lcolor, lwt, hwidth, hlength, htype
xlDialogPatternsbauto, bstyle, bcolor, bwt, shadow, aauto, apattern, afore, aback, rounded, newui
xlDialogPatternsbauto, bstyle, bcolor, bwt, shadow, aauto, apattern, afore, aback, invert, apply, newfill
xlDialogPatternslauto, lstyle, lcolor, lwt, tmajor, tminor, tlabel
xlDialogPatternslauto, lstyle, lcolor, lwt, apply, smooth
xlDialogPatternslauto, lstyle, lcolor, lwt, mauto, mstyle, mfore, mback, apply, smooth
xlDialogPatternstype, picture_units, apply
xlDialogPhonetic
xlDialogPivotCalculatedField
xlDialogPivotCalculatedItem
xlDialogPivotClientServerSet
xlDialogPivotFieldGroupstart, end, by, periods
xlDialogPivotFieldPropertiesname, pivot_field_name, new_name, orientation, function, formats
xlDialogPivotFieldUngroup
xlDialogPivotShowPagesname, page_field
xlDialogPivotSolveOrder
xlDialogPivotTableOptions
xlDialogPivotTableWizardtype, source, destination, name, row_grand, col_grand, save_data, apply_auto_format, auto_page, reserved
xlDialogPlacementplacement_type
xlDialogPrintrange_num, from, to, copies, draft, preview, print_what, color, feed, quality, y_resolution, selection, printer_text, print_to_file, collate
xlDialogPrinterSetupprinter_text
xlDialogPrintPreview
xlDialogPromoterowcol
xlDialogPropertiestitle, subject, author, keywords, comments
xlDialogProtectDocumentcontents, windows, password, objects, scenarios
xlDialogProtectSharing
xlDialogPublishAsWebPage
xlDialogPushbuttonPropertiesdefault_logical, cancel_logical, dismiss_logical, help_logical, accel_text, accel_text2
xlDialogReplaceFontfont_num, name_text, size_num, bold, italic, underline, strike, color, outline, shadow
xlDialogRoutingSliprecipients, subject, message, route_num, return_logical, status_logical
xlDialogRowHeightheight_num, reference, standard_height, type_num
xlDialogRunreference, step
xlDialogSaveAsdocument_text, type_num, prot_pwd, backup, write_res_pwd, read_only_rec
xlDialogSaveCopyAsdocument_text
xlDialogSaveNewObject
xlDialogSaveWorkbookdocument_text, type_num, prot_pwd, backup, write_res_pwd, read_only_rec
xlDialogSaveWorkspacename_text
xlDialogScalecross, cat_labels, cat_marks, between, max, reverse
xlDialogScalemin_num, max_num, major, minor, cross, logarithmic, reverse, max
xlDialogScalecat_labels, cat_marks, reverse, between
xlDialogScaleseries_labels, series_marks, reverse
xlDialogScalemin_num, max_num, major, minor, cross, logarithmic, reverse, min
xlDialogScenarioAddscen_name, value_array, changing_ref, scen_comment, locked, hidden
xlDialogScenarioCellschanging_ref
xlDialogScenarioEditscen_name, new_scenname, value_array, changing_ref, scen_comment, locked, hidden
xlDialogScenarioMergesource_file
xlDialogScenarioSummaryresult_ref, report_type
xlDialogScrollbarPropertiesvalue, min, max, inc, page, link, 3d_shading
xlDialogSelectSpecialtype_num, value_type, levels
xlDialogSendMailrecipients, subject, return_receipt
xlDialogSeriesAxesaxis_num
xlDialogSeriesOptions
xlDialogSeriesOrderchart_num, old_series_num, new_series_num
xlDialogSeriesShape
xlDialogSeriesXx_ref
xlDialogSeriesYname_ref, y_ref
xlDialogSetBackgroundPicture
xlDialogSetPrintTitlestitles_for_cols_ref, titles_for_rows_ref
xlDialogSetUpdateStatuslink_text, status, type_of_link
xlDialogShowDetailrowcol, rowcol_num, expand, show_field
xlDialogShowToolbarbar_id, visible, dock, x_pos, y_pos, width, protect, tool_tips, large_buttons, color_buttons
xlDialogSizewidth, height, window_text
xlDialogSortorientation, key1, order1, key2, order2, key3, order3, header, custom, case
xlDialogSortorientation, key1, order1, type, custom
xlDialogSortSpecialsort_by, method, key1, order1, key2, order2, key3, order3, header, order, case
xlDialogSplitcol_split, row_split
xlDialogStandardFontname_text, size_num, bold, italic, underline, strike, color, outline, shadow
xlDialogStandardWidthstandard_num
xlDialogStylebold, italic
xlDialogSubscribeTofile_text, format_num
xlDialogSubtotalCreateat_change_in, function_num, total, replace, pagebreaks, summary_below
xlDialogSummaryInfotitle, subject, author, keywords, comments
xlDialogTablerow_ref, column_ref
xlDialogTabOrder
xlDialogTextToColumnsdestination_ref, data_type, text_delim, consecutive_delim, tab, semicolon, comma, space, other, other_char, field_info
xlDialogUnhidewindow_text
xlDialogUpdateLinklink_text, type_of_link
xlDialogVbaInsertFilefilename_text
xlDialogVbaMakeAddIn
xlDialogVbaProcedureDefinition
xlDialogView3delevation, perspective, rotation, axes, height%, autoscale
xlDialogWebOptionsEncoding
xlDialogWebOptionsFiles
xlDialogWebOptionsFonts
xlDialogWebOptionsGeneral
xlDialogWebOptionsPictures
xlDialogWindowMovex_pos, y_pos, window_text
xlDialogWindowSizewidth, height, window_text
xlDialogWorkbookAddname_array, dest_book, position_num
xlDialogWorkbookCopyname_array, dest_book, position_num
xlDialogWorkbookInserttype_num
xlDialogWorkbookMovename_array, dest_book, position_num
xlDialogWorkbookNameoldname_text, newname_text
xlDialogWorkbookNew
xlDialogWorkbookOptionssheet_name, bound_logical, new_name
xlDialogWorkbookProtectstructure, windows, password
xlDialogWorkbookTabSplitratio_num
xlDialogWorkbookUnhidesheet_text
xlDialogWorkgroupname_array
xlDialogWorkspacefixed, decimals, r1c1, scroll, status, formula, menu_key, remote, entermove, underlines, tools, notes, nav_keys, menu_key_action, drag_drop, show_info
xlDialogZoommagnification


Community Additions

ADD
Show:
© 2015 Microsoft