| Dialog box constant | Argument list(s) |
|---|---|
| xlDialogActivate | window_text, pane_num |
| xlDialogActiveCellFont | font, font_style, size, strikethrough, superscript, subscript, outline, shadow, underline, color, normal, background, start_char, char_count |
| xlDialogAddChartAutoformat | name_text, desc_text |
| xlDialogAddinManager | operation_num, addinname_text, copy_logical |
| xlDialogAlignment | horiz_align, wrap, vert_align, orientation, add_indent |
| xlDialogApplyNames | name_array, ignore, use_rowcol, omit_col, omit_row, order_num, append_last |
| xlDialogApplyStyle | style_text |
| xlDialogAppMove | x_num, y_num |
| xlDialogAppSize | x_num, y_num |
| xlDialogArrangeAll | arrange_num, active_doc, sync_horiz, sync_vert |
| xlDialogAssignToObject | macro_ref |
| xlDialogAssignToTool | bar_id, position, macro_ref |
| xlDialogAttachText | attach_to_num, series_num, point_num |
| xlDialogAttachToolbars | |
| xlDialogAutoCorrect | correct_initial_caps, capitalize_days |
| xlDialogAxes | x_primary, y_primary, x_secondary, y_secondary |
| xlDialogAxes | x_primary, y_primary, z_primary |
| xlDialogBorder | outline, left, right, top, bottom, shade, outline_color, left_color, right_color, top_color, bottom_color |
| xlDialogCalculation | type_num, iter, max_num, max_change, update, precision, date_1904, calc_save, save_values, alt_exp, alt_form |
| xlDialogCellProtection | locked, hidden |
| xlDialogChangeLink | old_text, new_text, type_of_link |
| xlDialogChartAddData | ref, rowcol, titles, categories, replace, series |
| xlDialogChartLocation | |
| xlDialogChartOptionsDataLabels | |
| xlDialogChartOptionsDataTable | |
| xlDialogChartSourceData | |
| xlDialogChartTrend | type, ord_per, forecast, backcast, intercept, equation, r_squared, name |
| xlDialogChartType | |
| xlDialogChartWizard | long, ref, gallery_num, type_num, plot_by, categories, ser_titles, legend, title, x_title, y_title, z_title, number_cats, number_titles |
| xlDialogCheckboxProperties | value, link, accel_text, accel2_text, 3d_shading |
| xlDialogClear | type_num |
| xlDialogColorPalette | file_text |
| xlDialogColumnWidth | width_num, reference, standard, type_num, standard_num |
| xlDialogCombination | type_num |
| xlDialogConditionalFormatting | |
| xlDialogConsolidate | source_refs, function_num, top_row, left_col, create_links |
| xlDialogCopyChart | size_num |
| xlDialogCopyPicture | appearance_num, size_num, type_num |
| xlDialogCreateNames | top, left, bottom, right |
| xlDialogCreatePublisher | file_text, appearance, size, formats |
| xlDialogCustomizeToolbar | category |
| xlDialogCustomViews | |
| xlDialogDataDelete | |
| xlDialogDataLabel | show_option, auto_text, show_key |
| xlDialogDataSeries | rowcol, type_num, date_num, step_value, stop_value, trend |
| xlDialogDataValidation | |
| xlDialogDefineName | name_text, refers_to, macro_type, shortcut_text, hidden, category, local |
| xlDialogDefineStyle | style_text, number, font, alignment, border, pattern, protection |
| xlDialogDefineStyle | style_text, attribute_num, additional_def_args, ... |
| xlDialogDeleteFormat | format_text |
| xlDialogDeleteName | name_text |
| xlDialogDemote | row_col |
| xlDialogDisplay | formulas, gridlines, headings, zeros, color_num, reserved, outline, page_breaks, object_num |
| xlDialogDisplay | cell, formula, value, format, protection, names, precedents, dependents, note |
| xlDialogEditboxProperties | validation_num, multiline_logical, vscroll_logical, password_logical |
| xlDialogEditColor | color_num, red_value, green_value, blue_value |
| xlDialogEditDelete | shift_num |
| xlDialogEditionOptions | edition_type, edition_name, reference, option, appearance, size, formats |
| xlDialogEditSeries | series_num, name_ref, x_ref, y_ref, z_ref, plot_order |
| xlDialogErrorbarX | include, type, amount, minus |
| xlDialogErrorbarY | include, type, amount, minus |
| xlDialogExternalDataProperties | |
| xlDialogExtract | unique |
| xlDialogFileDelete | file_text |
| xlDialogFileSharing | |
| xlDialogFillGroup | type_num |
| xlDialogFillWorkgroup | type_num |
| xlDialogFilter | |
| xlDialogFilterAdvanced | operation, list_ref, criteria_ref, copy_ref, unique |
| xlDialogFindFile | |
| xlDialogFont | name_text, size_num |
| xlDialogFontProperties | font, font_style, size, strikethrough, superscript, subscript, outline, shadow, underline, color, normal, background, start_char, char_count |
| xlDialogFormatAuto | format_num, number, font, alignment, border, pattern, width |
| xlDialogFormatChart | layer_num, view, overlap, angle, gap_width, gap_depth, chart_depth, doughnut_size, axis_num, drop, hilo, up_down, series_line, labels, vary |
| xlDialogFormatCharttype | apply_to, group_num, dimension, type_num |
| xlDialogFormatFont | color, backgd, apply, name_text, size_num, bold, italic, underline, strike, outline, shadow, object_id, start_num, char_num |
| xlDialogFormatFont | name_text, size_num, bold, italic, underline, strike, color, outline, shadow |
| xlDialogFormatFont | name_text, size_num, bold, italic, underline, strike, color, outline, shadow, object_id_text, start_num, char_num |
| xlDialogFormatLegend | position_num |
| xlDialogFormatMain | type_num, view, overlap, gap_width, vary, drop, hilo, angle, gap_depth, chart_depth, up_down, series_line, labels, doughnut_size |
| xlDialogFormatMove | x_offset, y_offset, reference |
| xlDialogFormatMove | x_pos, y_pos |
| xlDialogFormatMove | explosion_num |
| xlDialogFormatNumber | format_text |
| xlDialogFormatOverlay | type_num, view, overlap, gap_width, vary, drop, hilo, angle, series_dist, series_num, up_down, series_line, labels, doughnut_size |
| xlDialogFormatSize | width, height |
| xlDialogFormatSize | x_off, y_off, reference |
| xlDialogFormatText | x_align, y_align, orient_num, auto_text, auto_size, show_key, show_value, add_indent |
| xlDialogFormulaFind | text, in_num, at_num, by_num, dir_num, match_case, match_byte |
| xlDialogFormulaGoto | reference, corner |
| xlDialogFormulaReplace | find_text, replace_text, look_at, look_by, active_cell, match_case, match_byte |
| xlDialogFunctionWizard | |
| xlDialogGallery3dArea | type_num |
| xlDialogGallery3dBar | type_num |
| xlDialogGallery3dColumn | type_num |
| xlDialogGallery3dLine | type_num |
| xlDialogGallery3dPie | type_num |
| xlDialogGallery3dSurface | type_num |
| xlDialogGalleryArea | type_num, delete_overlay |
| xlDialogGalleryBar | type_num, delete_overlay |
| xlDialogGalleryColumn | type_num, delete_overlay |
| xlDialogGalleryCustom | name_text |
| xlDialogGalleryDoughnut | type_num, delete_overlay |
| xlDialogGalleryLine | type_num, delete_overlay |
| xlDialogGalleryPie | type_num, delete_overlay |
| xlDialogGalleryRadar | type_num, delete_overlay |
| xlDialogGalleryScatter | type_num, delete_overlay |
| xlDialogGoalSeek | target_cell, target_value, variable_cell |
| xlDialogGridlines | x_major, x_minor, y_major, y_minor, z_major, z_minor, 2D_effect |
| xlDialogImportTextFile | |
| xlDialogInsert | shift_num |
| xlDialogInsertHyperlink | |
| xlDialogInsertNameLabel | |
| xlDialogInsertObject | object_class, file_name, link_logical, display_icon_logical, icon_file, icon_number, icon_label |
| xlDialogInsertPicture | file_name, filter_number |
| xlDialogInsertTitle | chart, y_primary, x_primary, y_secondary, x_secondary |
| xlDialogLabelProperties | accel_text, accel2_text, 3d_shading |
| xlDialogListboxProperties | range, link, drop_size, multi_select, 3d_shading |
| xlDialogMacroOptions | macro_name, description, menu_on, menu_text, shortcut_on, shortcut_key, function_category, status_bar_text, help_id, help_file |
| xlDialogMailEditMailer | to_recipients, cc_recipients, bcc_recipients, subject, enclosures, which_address |
| xlDialogMailLogon | name_text, password_text, download_logical |
| xlDialogMailNextLetter | |
| xlDialogMainChart | type_num, stack, 100, vary, overlap, drop, hilo, overlap%, cluster, angle |
| xlDialogMainChartType | type_num |
| xlDialogMenuEditor | |
| xlDialogMove | x_pos, y_pos, window_text |
| xlDialogNew | type_num, xy_series, add_logical |
| xlDialogNewWebQuery | |
| xlDialogNote | add_text, cell_ref, start_char, num_chars |
| xlDialogObjectProperties | placement_type, print_object |
| xlDialogObjectProtection | locked, lock_text |
| xlDialogOpen | file_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 |
| xlDialogOpenLinks | document_text1, document_text2, ..., read_only, type_of_link |
| xlDialogOpenMail | subject, comments |
| xlDialogOpenText | file_name, file_origin, start_row, file_type, text_qualifier, consecutive_delim, tab, semicolon, comma, space, other, other_char, field_info |
| xlDialogOptionsCalculation | type_num, iter, max_num, max_change, update, precision, date_1904, calc_save, save_values |
| xlDialogOptionsChart | display_blanks, plot_visible, size_with_window |
| xlDialogOptionsEdit | incell_edit, drag_drop, alert, entermove, fixed, decimals, copy_objects, update_links, move_direction, autocomplete, animations |
| xlDialogOptionsGeneral | R1C1_mode, dde_on, sum_info, tips, recent_files, old_menus, user_info, font_name, font_size, default_location, alternate_location, sheet_num, enable_under |
| xlDialogOptionsListsAdd | string_array |
| xlDialogOptionsListsAdd | import_ref, by_row |
| xlDialogOptionsME | def_rtl_sheet, crsr_mvmt, show_ctrl_char, gui_lang |
| xlDialogOptionsTransition | menu_key, menu_key_action, nav_keys, trans_eval, trans_entry |
| xlDialogOptionsView | formula, status, notes, show_info, object_num, page_breaks, formulas, gridlines, color_num, headers, outline, zeros, hor_scroll, vert_scroll, sheet_tabs |
| xlDialogOutline | auto_styles, row_dir, col_dir, create_apply |
| xlDialogOverlay | type_num, stack, 100, vary, overlap, drop, hilo, overlap%, cluster, angle, series_num, auto |
| xlDialogOverlayChartType | type_num |
| xlDialogPageSetup | head, 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 |
| xlDialogPageSetup | head, foot, left, right, top, bot, size, h_cntr, v_cntr, orient, paper_size, scale, pg_num, bw_chart, quality, head_margin, foot_margin, draft |
| xlDialogPageSetup | head, foot, left, right, top, bot, orient, paper_size, scale, quality, head_margin, foot_margin, pg_num |
| xlDialogParse | parse_text, destination_ref |
| xlDialogPasteNames | |
| xlDialogPasteSpecial | paste_num, operation_num, skip_blanks, transpose |
| xlDialogPasteSpecial | rowcol, titles, categories, replace, series |
| xlDialogPasteSpecial | paste_num |
| xlDialogPasteSpecial | format_text, pastelink_logical, display_icon_logical, icon_file, icon_number, icon_label |
| xlDialogPatterns | apattern, afore, aback, newui |
| xlDialogPatterns | lauto, lstyle, lcolor, lwt, hwidth, hlength, htype |
| xlDialogPatterns | bauto, bstyle, bcolor, bwt, shadow, aauto, apattern, afore, aback, rounded, newui |
| xlDialogPatterns | bauto, bstyle, bcolor, bwt, shadow, aauto, apattern, afore, aback, invert, apply, newfill |
| xlDialogPatterns | lauto, lstyle, lcolor, lwt, tmajor, tminor, tlabel |
| xlDialogPatterns | lauto, lstyle, lcolor, lwt, apply, smooth |
| xlDialogPatterns | lauto, lstyle, lcolor, lwt, mauto, mstyle, mfore, mback, apply, smooth |
| xlDialogPatterns | type, picture_units, apply |
| xlDialogPhonetic | |
| xlDialogPivotCalculatedField | |
| xlDialogPivotCalculatedItem | |
| xlDialogPivotClientServerSet | xlDialogPivotFieldGroup | start, end, by, periods |
| xlDialogPivotFieldProperties | name, pivot_field_name, new_name, orientation, function, formats |
| xlDialogPivotFieldUngroup | |
| xlDialogPivotShowPages | name, page_field |
| xlDialogPivotSolveOrder | |
| xlDialogPivotTableOptions | |
| xlDialogPivotTableWizard | type, source, destination, name, row_grand, col_grand, save_data, apply_auto_format, auto_page, reserved |
| xlDialogPlacement | placement_type |
| xlDialogPrint | range_num, from, to, copies, draft, preview, print_what, color, feed, quality, y_resolution, selection, printer_text, print_to_file, collate |
| xlDialogPrinterSetup | printer_text |
| xlDialogPrintPreview | |
| xlDialogPromote | rowcol |
| xlDialogProperties | title, subject, author, keywords, comments |
| xlDialogProtectDocument | contents, windows, password, objects, scenarios |
| xlDialogProtectSharing | |
| xlDialogPublishAsWebPage | |
| xlDialogPushbuttonProperties | default_logical, cancel_logical, dismiss_logical, help_logical, accel_text, accel_text2 |
| xlDialogReplaceFont | font_num, name_text, size_num, bold, italic, underline, strike, color, outline, shadow |
| xlDialogRoutingSlip | recipients, subject, message, route_num, return_logical, status_logical |
| xlDialogRowHeight | height_num, reference, standard_height, type_num |
| xlDialogRun | reference, step |
| xlDialogSaveAs | document_text, type_num, prot_pwd, backup, write_res_pwd, read_only_rec |
| xlDialogSaveCopyAs | document_text |
| xlDialogSaveNewObject | |
| xlDialogSaveWorkbook | document_text, type_num, prot_pwd, backup, write_res_pwd, read_only_rec |
| xlDialogSaveWorkspace | name_text |
| xlDialogScale | cross, cat_labels, cat_marks, between, max, reverse |
| xlDialogScale | min_num, max_num, major, minor, cross, logarithmic, reverse, max |
| xlDialogScale | cat_labels, cat_marks, reverse, between |
| xlDialogScale | series_labels, series_marks, reverse |
| xlDialogScale | min_num, max_num, major, minor, cross, logarithmic, reverse, min |
| xlDialogScenarioAdd | scen_name, value_array, changing_ref, scen_comment, locked, hidden |
| xlDialogScenarioCells | changing_ref |
| xlDialogScenarioEdit | scen_name, new_scenname, value_array, changing_ref, scen_comment, locked, hidden |
| xlDialogScenarioMerge | source_file |
| xlDialogScenarioSummary | result_ref, report_type |
| xlDialogScrollbarProperties | value, min, max, inc, page, link, 3d_shading |
| xlDialogSelectSpecial | type_num, value_type, levels |
| xlDialogSendMail | recipients, subject, return_receipt |
| xlDialogSeriesAxes | axis_num |
| xlDialogSeriesOptions | |
| xlDialogSeriesOrder | chart_num, old_series_num, new_series_num |
| xlDialogSeriesShape | |
| xlDialogSeriesX | x_ref |
| xlDialogSeriesY | name_ref, y_ref |
| xlDialogSetBackgroundPicture | |
| xlDialogSetPrintTitles | titles_for_cols_ref, titles_for_rows_ref |
| xlDialogSetUpdateStatus | link_text, status, type_of_link |
| xlDialogShowDetail | rowcol, rowcol_num, expand, show_field |
| xlDialogShowToolbar | bar_id, visible, dock, x_pos, y_pos, width, protect, tool_tips, large_buttons, color_buttons |
| xlDialogSize | width, height, window_text |
| xlDialogSort | orientation, key1, order1, key2, order2, key3, order3, header, custom, case |
| xlDialogSort | orientation, key1, order1, type, custom |
| xlDialogSortSpecial | sort_by, method, key1, order1, key2, order2, key3, order3, header, order, case |
| xlDialogSplit | col_split, row_split |
| xlDialogStandardFont | name_text, size_num, bold, italic, underline, strike, color, outline, shadow |
| xlDialogStandardWidth | standard_num |
| xlDialogStyle | bold, italic |
| xlDialogSubscribeTo | file_text, format_num |
| xlDialogSubtotalCreate | at_change_in, function_num, total, replace, pagebreaks, summary_below |
| xlDialogSummaryInfo | title, subject, author, keywords, comments |
| xlDialogTable | row_ref, column_ref |
| xlDialogTabOrder | |
| xlDialogTextToColumns | destination_ref, data_type, text_delim, consecutive_delim, tab, semicolon, comma, space, other, other_char, field_info |
| xlDialogUnhide | window_text |
| xlDialogUpdateLink | link_text, type_of_link |
| xlDialogVbaInsertFile | filename_text |
| xlDialogVbaMakeAddIn | |
| xlDialogVbaProcedureDefinition | |
| xlDialogView3d | elevation, perspective, rotation, axes, height%, autoscale |
| xlDialogWebOptionsEncoding | |
| xlDialogWebOptionsFiles | |
| xlDialogWebOptionsFonts | |
| xlDialogWebOptionsGeneral | |
| xlDialogWebOptionsPictures | |
| xlDialogWindowMove | x_pos, y_pos, window_text |
| xlDialogWindowSize | width, height, window_text |
| xlDialogWorkbookAdd | name_array, dest_book, position_num |
| xlDialogWorkbookCopy | name_array, dest_book, position_num |
| xlDialogWorkbookInsert | type_num |
| xlDialogWorkbookMove | name_array, dest_book, position_num |
| xlDialogWorkbookName | oldname_text, newname_text |
| xlDialogWorkbookNew | |
| xlDialogWorkbookOptions | sheet_name, bound_logical, new_name |
| xlDialogWorkbookProtect | structure, windows, password |
| xlDialogWorkbookTabSplit | ratio_num |
| xlDialogWorkbookUnhide | sheet_text |
| xlDialogWorkgroup | name_array |
| xlDialogWorkspace | fixed, decimals, r1c1, scroll, status, formula, menu_key, remote, entermove, underlines, tools, notes, nav_keys, menu_key_action, drag_drop, show_info |
| xlDialogZoom | magnification |