Aus VBA heraus kann der größte Teil der Excel-Dialoge aufgerufen werden. Nicht alle Dialoge sind
funktionsfähig. Zum Teil benötigen sie eine bestimmte Umgebung, um erwartete Aktionen ausführen zu können -
beispielsweise können Dialoge zu Diagrammen nur dann wirksam werden, wenn ein Diagramm vorhanden ist -,
zum Teil werden - wie z.B. bei einer Farbauswahl - nicht die erwarteten Werte zurückgeliefert, oder die
Dialoge sind wie z.B. der
-Schaltfläche.
In der zugehörigen Beispielarbeitsmappe können Sie durch einfaches Anklicken der jeweiligen Dialoge den
Dialogaufruf testen.
sowohl mit ihrem Namen - z.B.
xlDialogActivate - wie auch mit ihrem Wert - in diesem Fall 103 - aufgerufen werden. Dem Aufruf können
Argumente mitgegeben werden.
Eine Auflistung aller Excel-Dialoge mit ihren Indizes und ihren Argumenten erhalten Sie hier:
Die eingebauten Excel-Dialoge sind nicht deckungsgleich mit den im manuellen Arbeiten in Excel bekannten
Dialogen. Wird beispielsweise der
-Menü aufgerufen, besteht
er aus verschiedenen Registern, aus denen ausgewählt werden kann:
-Dialogs können über VBA einzeln aufgerufen werden, was zur
benutzerfreundlichkeit beitragen kann.
Dem Aufruf können Parameter mitgegeben werden, um damit die Aufrufeinstellungen zu beeinflussen. Für
den
Dialog | Index | Argumente |
xlDialogActivate | 103 | window_text, pane_num |
xlDialogActiveCellFont | 476 | font, font_style, size, strikethrough, superscript, subscript, outline, shadow, underline, color, normal, background, start_char, char_count |
xlDialogAddChartAutoformat | 390 | name_text, desc_text |
xlDialogAddinManager | 321 | operation_num, addinname_text, copy_logical |
xlDialogAlignment | 43 | horiz_align, wrap, vert_align, orientation, add_indent |
xlDialogApplyNames | 133 | name_array, ignore, use_rowcol, omit_col, omit_row, order_num, append_last |
xlDialogApplyStyle | 212 | style_text |
xlDialogAppMove | 170 | x_num, y_num |
xlDialogAppSize | 171 | x_num, y_num |
xlDialogArrangeAll | 12 | arrange_num, active_doc, sync_horiz, sync_vert |
xlDialogAssignToObject | 213 | macro_ref |
xlDialogAssignToTool | 293 | bar_id, position, macro_ref |
xlDialogAttachText | 80 | attach_to_num, series_num, point_num |
xlDialogAttachToolbars | 323 | |
xlDialogAutoCorrect | 485 | correct_initial_caps, capitalize_days |
xlDialogAxes | 78 | x_primary, y_primary, z_primary |
xlDialogBorder | 45 | outline, left, right, top, bottom, shade, outline_color, left_color, right_color, top_color, bottom_color |
xlDialogCalculation | 32 | type_num, iter, max_num, max_change, update, precision, date_1904, calc_save, save_values, alt_exp, alt_form |
xlDialogCellProtection | 46 | locked, hidden |
xlDialogChangeLink | 166 | old_text, new_text, type_of_link |
xlDialogChartAddData | 392 | ref, rowcol, titles, categories, replace, series |
xlDialogChartTrend | 350 | type, ord_per, forecast, backcast, intercept, equation, r_squared, name |
xlDialogChartWizard | 288 | long, ref, gallery_num, type_num, plot_by, categories, ser_titles, legend, title, x_title, y_title, z_title, number_cats, number_titles |
xlDialogCheckboxProperties | 435 | value, link, accel_text, accel2_text, 3d_shading |
xlDialogClear | 52 | type_num |
xlDialogColorPalette | 161 | file_text |
xlDialogColumnWidth | 47 | width_num, reference, standard, type_num, standard_num |
xlDialogCombination | 73 | type_num |
xlDialogConsolidate | 191 | source_refs, function_num, top_row, left_col, create_links |
xlDialogCopyChart | 147 | size_num |
xlDialogCopyPicture | 108 | appearance_num, size_num, type_num |
xlDialogCreateNames | 62 | top, left, bottom, right |
xlDialogCreatePublisher | 217 | file_text, appearance, size, formats |
xlDialogCustomizeToolbar | 276 | category |
xlDialogDataDelete | 36 | |
xlDialogDataLabel | 379 | show_option, auto_text, show_key |
xlDialogDataSeries | 40 | rowcol, type_num, date_num, step_value, stop_value, trend |
xlDialogDefineName | 61 | name_text, refers_to, macro_type, shortcut_text, hidden, category, local |
xlDialogDefineStyle | 229 | style_text, attribute_num, additional_def_args, ... |
xlDialogDeleteFormat | 111 | format_text |
xlDialogDeleteName | 110 | name_text |
xlDialogDemote | 203 | row_col |
xlDialogDisplay | 27 | cell, formula, value, format, protection, names, precedents, dependents, note |
xlDialogEditboxProperties | 438 | validation_num, multiline_logical, vscroll_logical, password_logical |
xlDialogEditColor | 223 | color_num, red_value, green_value, blue_value |
xlDialogEditDelete | 54 | shift_num |
xlDialogEditionOptions | 251 | edition_type, edition_name, reference, option, appearance, size, formats |
xlDialogEditSeries | 228 | series_num, name_ref, x_ref, y_ref, z_ref, plot_order |
xlDialogErrorbarX | 463 | include, type, amount, minus |
xlDialogErrorbarY | 464 | include, type, amount, minus |
xlDialogExtract | 35 | unique |
xlDialogFileDelete | 6 | file_text |
xlDialogFillGroup | 200 | type_num |
xlDialogFillWorkgroup | 301 | type_num |
xlDialogFilterAdvanced | 370 | operation, list_ref, criteria_ref, copy_ref, unique |
xlDialogFindFile | 475 | |
xlDialogFont | 26 | name_text, size_num |
xlDialogFontProperties | 381 | font, font_style, size, strikethrough, superscript, subscript, outline, shadow, underline, color, normal, background, start_char, char_count |
xlDialogFormatAuto | 269 | format_num, number, font, alignment, border, pattern, width |
xlDialogFormatChart | 465 | layer_num, view, overlap, angle, gap_width, gap_depth, chart_depth, doughnut_size, axis_num, drop, hilo, up_down, series_line, labels, vary |
xlDialogFormatCharttype | 423 | apply_to, group_num, dimension, type_num |
xlDialogFormatFont | 150 | name_text, size_num, bold, italic, underline, strike, color, outline, shadow, object_id_text, start_num, char_num |
xlDialogFormatLegend | 88 | position_num |
xlDialogFormatMain | 225 | type_num, view, overlap, gap_width, vary, drop, hilo, angle, gap_depth, chart_depth, up_down, series_line, labels, doughnut_size |
xlDialogFormatMove | 128 | explosion_num |
xlDialogFormatNumber | 42 | format_text |
xlDialogFormatOverlay | 226 | type_num, view, overlap, gap_width, vary, drop, hilo, angle, series_dist, series_num, up_down, series_line, labels, doughnut_size |
xlDialogFormatSize | 129 | x_off, y_off, reference |
xlDialogFormatText | 89 | x_align, y_align, orient_num, auto_text, auto_size, show_key, show_value, add_indent |
xlDialogFormulaFind | 64 | text, in_num, at_num, by_num, dir_num, match_case, match_byte |
xlDialogFormulaGoto | 63 | reference, corner |
xlDialogFormulaReplace | 130 | find_text, replace_text, look_at, look_by, active_cell, match_case, match_byte |
xlDialogFunctionWizard | 450 | |
xlDialogGallery3dArea | 193 | type_num |
xlDialogGallery3dBar | 272 | type_num |
xlDialogGallery3dColumn | 194 | type_num |
xlDialogGallery3dLine | 195 | type_num |
xlDialogGallery3dPie | 196 | type_num |
xlDialogGallery3dSurface | 273 | type_num |
xlDialogGalleryArea | 67 | type_num, delete_overlay |
xlDialogGalleryBar | 68 | type_num, delete_overlay |
xlDialogGalleryColumn | 69 | type_num, delete_overlay |
xlDialogGalleryCustom | 388 | name_text |
xlDialogGalleryDoughnut | 344 | type_num, delete_overlay |
xlDialogGalleryLine | 70 | type_num, delete_overlay |
xlDialogGalleryPie | 71 | type_num, delete_overlay |
xlDialogGalleryRadar | 249 | type_num, delete_overlay |
xlDialogGalleryScatter | 72 | type_num, delete_overlay |
xlDialogGoalSeek | 198 | target_cell, target_value, variable_cell |
xlDialogGridlines | 76 | x_major, x_minor, y_major, y_minor, z_major, z_minor, 2D_effect |
xlDialogInsert | 55 | shift_num |
xlDialogInsertObject | 259 | object_class, file_name, link_logical, display_icon_logical, icon_file, icon_number, icon_label |
xlDialogInsertPicture | 342 | file_name, filter_number |
xlDialogInsertTitle | 380 | chart, y_primary, x_primary, y_secondary, x_secondary |
xlDialogLabelProperties | 436 | accel_text, accel2_text, 3d_shading |
xlDialogListboxProperties | 437 | range, link, drop_size, multi_select, 3d_shading |
xlDialogMacroOptions | 382 | macro_name, description, menu_on, menu_text, shortcut_on, shortcut_key, function_category, status_bar_text, help_id, help_file |
xlDialogMailEditMailer | 470 | to_recipients, cc_recipients, bcc_recipients, subject, enclosures, which_address |
xlDialogMailLogon | 339 | name_text, password_text, download_logical |
xlDialogMailNextLetter | 378 | |
xlDialogMainChart | 85 | type_num, stack, 100, vary, overlap, drop, hilo, overlap%, cluster, angle |
xlDialogMainChartType | 185 | type_num |
xlDialogMenuEditor | 322 | |
xlDialogMove | 262 | x_pos, y_pos, window_text |
xlDialogNew | 119 | type_num, xy_series, add_logical |
xlDialogNote | 154 | add_text, cell_ref, start_char, num_chars |
xlDialogObjectProperties | 207 | placement_type, print_object |
xlDialogObjectProtection | 214 | locked, lock_text |
xlDialogOpen | 1 | 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 | 2 | document_text1, document_text2, ..., read_only, type_of_link |
xlDialogOpenMail | 188 | subject, comments |
xlDialogOpenText | 441 | file_name, file_origin, start_row, file_type, text_qualifier, consecutive_delim, tab, semicolon, comma, space, other, other_char, field_info |
xlDialogOptionsCalculation | 318 | type_num, iter, max_num, max_change, update, precision, date_1904, calc_save, save_values |
xlDialogOptionsChart | 325 | display_blanks, plot_visible, size_with_window |
xlDialogOptionsEdit | 319 | incell_edit, drag_drop, alert, entermove, fixed, decimals, copy_objects, update_links, move_direction, autocomplete, animations |
xlDialogOptionsGeneral | 356 | 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 | 458 | import_ref, by_row |
xlDialogOptionsTransition | 355 | menu_key, menu_key_action, nav_keys, trans_eval, trans_entry |
xlDialogOptionsView | 320 | formula, status, notes, show_info, object_num, page_breaks, formulas, gridlines, color_num, headers, outline, zeros, hor_scroll, vert_scroll, sheet_tabs |
xlDialogOutline | 142 | auto_styles, row_dir, col_dir, create_apply |
xlDialogOverlay | 86 | type_num, stack, 100, vary, overlap, drop, hilo, overlap%, cluster, angle, series_num, auto |
xlDialogOverlayChartType | 186 | type_num |
xlDialogPageSetup | 7 | head, foot, left, right, top, bot, orient, paper_size, scale, quality, head_margin, foot_margin, pg_num |
xlDialogParse | 91 | parse_text, destination_ref |
xlDialogPasteSpecial | 53 | format_text, pastelink_logical, display_icon_logical, icon_file, icon_number, icon_label |
xlDialogPatterns | 84 | type, picture_units, apply |
xlDialogPivotFieldGroup | 433 | start, end, by, periods |
xlDialogPivotFieldProperties | 313 | name, pivot_field_name, new_name, orientation, function, formats |
xlDialogPivotFieldUngroup | 434 | |
xlDialogPivotShowPages | 421 | name, page_field |
xlDialogPivotTableWizard | 312 | type, source, destination, name, row_grand, col_grand, save_data, apply_auto_format, auto_page, reserved |
xlDialogPlacement | 300 | placement_type |
xlDialogPrint | 8 | range_num, from, to, copies, draft, preview, print_what, color, feed, quality, y_resolution, selection, printer_text, print_to_file, collate |
xlDialogPrinterSetup | 9 | printer_text |
xlDialogPrintPreview | 222 | |
xlDialogPromote | 202 | rowcol |
xlDialogProperties | 474 | title, subject, author, keywords, comments |
xlDialogProtectDocument | 28 | contents, windows, password, objects, scenarios |
xlDialogPushbuttonProperties | 445 | default_logical, cancel_logical, dismiss_logical, help_logical, accel_text, accel_text2 |
xlDialogReplaceFont | 134 | font_num, name_text, size_num, bold, italic, underline, strike, color, outline, shadow |
xlDialogRoutingSlip | 336 | recipients, subject, message, route_num, return_logical, status_logical |
xlDialogRowHeight | 127 | height_num, reference, standard_height, type_num |
xlDialogRun | 17 | reference, step |
xlDialogSaveAs | 5 | document_text, type_num, prot_pwd, backup, write_res_pwd, read_only_rec |
xlDialogSaveCopyAs | 456 | document_text |
xlDialogSaveNewObject | 208 | |
xlDialogSaveWorkbook | 145 | document_text, type_num, prot_pwd, backup, write_res_pwd, read_only_rec |
xlDialogSaveWorkspace | 285 | name_text |
xlDialogScale | 87 | min_num, max_num, major, minor, cross, logarithmic, reverse, min |
xlDialogScenarioAdd | 307 | scen_name, value_array, changing_ref, scen_comment, locked, hidden |
xlDialogScenarioCells | 305 | changing_ref |
xlDialogScenarioEdit | 308 | scen_name, new_scenname, value_array, changing_ref, scen_comment, locked, hidden |
xlDialogScenarioMerge | 473 | source_file |
xlDialogScenarioSummary | 311 | result_ref, report_type |
xlDialogScrollbarProperties | 420 | value, min, max, inc, page, link, 3d_shading |
xlDialogSelectSpecial | 132 | type_num, value_type, levels |
xlDialogSendMail | 189 | recipients, subject, return_receipt |
xlDialogSeriesAxes | 460 | axis_num |
xlDialogSeriesOrder | 466 | chart_num, old_series_num, new_series_num |
xlDialogSeriesX | 461 | x_ref |
xlDialogSeriesY | 462 | name_ref, y_ref |
xlDialogSetPrintTitles | 23 | titles_for_cols_ref, titles_for_rows_ref |
xlDialogSetUpdateStatus | 159 | link_text, status, type_of_link |
xlDialogShowDetail | 204 | rowcol, rowcol_num, expand, show_field |
xlDialogShowToolbar | 220 | bar_id, visible, dock, x_pos, y_pos, width, protect, tool_tips, large_buttons, color_buttons |
xlDialogSize | 261 | width, height, window_text |
xlDialogSort | 39 | orientation, key1, order1, type, custom |
xlDialogSortSpecial | 192 | sort_by, method, key1, order1, key2, order2, key3, order3, header, order, case |
xlDialogSplit | 137 | col_split, row_split |
xlDialogStandardFont | 190 | name_text, size_num, bold, italic, underline, strike, color, outline, shadow |
xlDialogStandardWidth | 472 | standard_num |
xlDialogStyle | 44 | bold, italic |
xlDialogSubscribeTo | 218 | file_text, format_num |
xlDialogSubtotalCreate | 398 | at_change_in, function_num, total, replace, pagebreaks, summary_below |
xlDialogSummaryInfo | 474 | title, subject, author, keywords, comments |
xlDialogTable | 41 | row_ref, column_ref |
xlDialogTabOrder | 394 | |
xlDialogTextToColumns | 422 | destination_ref, data_type, text_delim, consecutive_delim, tab, semicolon, comma, space, other, other_char, field_info |
xlDialogUnhide | 94 | window_text |
xlDialogUpdateLink | 201 | link_text, type_of_link |
xlDialogVbaInsertFile | 328 | filename_text |
xlDialogVbaMakeAddin | 478 | |
xlDialogVbaProcedureDefinition | 330 | |
xlDialogView3d | 197 | elevation, perspective, rotation, axes, height%, autoscale |
xlDialogWindowMove | 14 | x_pos, y_pos, window_text |
xlDialogWindowSize | 13 | width, height, window_text |
xlDialogWorkbookAdd | 281 | name_array, dest_book, position_num |
xlDialogWorkbookCopy | 283 | name_array, dest_book, position_num |
xlDialogWorkbookInsert | 354 | type_num |
xlDialogWorkbookMove | 282 | name_array, dest_book, position_num |
xlDialogWorkbookName | 386 | oldname_text, newname_text |
xlDialogWorkbookNew | 302 | |
xlDialogWorkbookOptions | 284 | sheet_name, bound_logical, new_name |
xlDialogWorkbookProtect | 417 | structure, windows, password |
xlDialogWorkbookTabSplit | 415 | ratio_num |
xlDialogWorkbookUnhide | 384 | sheet_text |
xlDialogWorkgroup | 199 | name_array |
xlDialogWorkspace | 95 | fixed, decimals, r1c1, scroll, status, formula, menu_key, remote, entermove, underlines, tools, notes, nav_keys, menu_key_action, drag_drop, show_info |
xlDialogZoom | 256 | magnification |