| 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 |