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