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 |