0160-93 82 19 37 | Nehmen Sie 
Übersicht aller integrierten Excel-Dialoge
108035
Das folgende Makro ruft einen in Excel integrierten Dialog auf. Im Beispiel den Dialog 'Speichern unter'. Die untenstehende Tabelle beinhaltet alle in Excel integrierten Dialoge, die entsprechend aufgerufen werden können. Setzt man die bereits vorhandenen Dialoge sinnvoll ein, kann man sich eine Menge Entwicklungsarbeit sparen!
Public Sub Dialog_aufrufen()
Application.Dialogs(xlDialogSaveAs).Show
End Sub
Dialogfeldkonstante
Argumentenliste
xlDialogActivate window_text, pane_num xlDialogActiveCellFont font, font_style, size, strikethrough, superscript, subscript, outline, shadow, underline, color,
normal, background, start_char, char_countxlDialogAddChartAutoformat 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_colorxlDialogCalculation type_num, iter, max_num, max_change, update, precision, date_1904,
calc_save, save_values, alt_exp, alt_formxlDialogCellProtection 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_titlesxlDialogCheckboxProperties 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_countxlDialogFormatAuto 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, varyxlDialogFormatCharttype 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_numxlDialogFormatFont 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_numxlDialogFormatLegend position_num xlDialogFormatMain type_num, view, overlap, gap_width, vary, drop, hilo, angle, gap_depth,
chart_depth, up_down, series_line, labels, doughnut_sizexlDialogFormatMove 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_sizexlDialogFormatSize 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_labelxlDialogInsertPicture 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_filexlDialogMailEditMailer 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, converterxlDialogOpenLinks 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_infoxlDialogOptionsCalculation type_num, iter, max_num, max_change, update, precision, date_1904,
calc_save, save_valuesxlDialogOptionsChart display_blanks, plot_visible, size_with_window xlDialogOptionsEdit incell_edit, drag_drop, alert, entermove, fixed, decimals, copy_objects, update_links,
move_direction, autocomplete, animationsxlDialogOptionsGeneral R1C1_mode, dde_on, sum_info, tips, recent_files, old_menus, user_info, font_name,
font_size, default_location, alternate_location, sheet_num, enable_underxlDialogOptionsListsAdd 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_tabsxlDialogOutline auto_styles, row_dir, col_dir, create_apply xlDialogOverlay type_num, stack, 100, vary, overlap, drop, hilo, overlap%, cluster, angle,
series_num, autoxlDialogOverlayChartType 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, draftxlDialogPageSetup head, foot, left, right, top, bot, size, h_cntr, v_cntr, orient, paper_size, scale, pg_num,
bw_chart, quality, head_margin, foot_margin, draftxlDialogPageSetup head, foot, left, right, top, bot, orient, paper_size, scale, quality, head_margin,
foot_margin, pg_numxlDialogParse 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, reservedxlDialogPlacement placement_type xlDialogPrint range_num, from, to, copies, draft, preview, print_what, color, feed, quality,
y_resolution, selection, printer_text, print_to_file, collatexlDialogPrinterSetup 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_infoxlDialogUnhide 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_infoxlDialogZoom magnification
