Excel Dialogs

 

The VBA code fragments below are included in the Code VBA fragments library. Fragments are snippets of code you can insert in your procedures. Each item between braces correspond to a variable of the given type. They are replaced with the new or existing variables by Fragment Builder in Code-VB tools.

Dialog delete file


Application.Dialogs(xlDialogFileDelete).Show {STRING:FileFilter}

Dialog open file


Application.Dialogs(xlDialogFindFile).Show

Set Filter on Active Column


Application.Dialogs(xlDialogFilter).Show

TODO dialogs


Application.DecimalSeparator
Application.DefaultFilePath
Application.Dialogs(xlDialogFindFile
Application.Dialogs(xlDialogDeleteName
XApplication.Dialogs(xlDialogClear
XApplication.Dialogs(xlDialogDisplay
XApplication.Dialogs(xlDialogEditSeries
Application.Dialogs(xlDialogFileDelete
Application.Dialogs(xlDialogFilter
Application.Dialogs(xlDialogFilterAdvanced

Application.Dialogs(xlDialogFunctionWizard
Application.Dialogs(xlDialogMailEditMailer
Application.Dialogs(xlDialogMailLogon
Application.Dialogs(xlDialogOpen
Application.Dialogs(xlxlDialogPasteSpecial
Application.Dialogs(xlDialogPrint
Application.Dialogs(xlDialogPublishAsWebPage
Application.Dialogs(xlDialogSaveAs
Application.Dialogs(xlDialogSaveCopyAs
Application.Dialogs(xlDialogSaveWorkbook
Application.Dialogs(xlDialogSearch
Application.Dialogs(xlDialogSendMail
Application.Dialogs(xlDialogSort
Application.Dialogs(xlDialogSortSpecial
Application.Dialogs(xlDialogUpdateLink
Application.Dialogs(xlDialogVbaInsertFile
Application.Dialogs(xlDialogVbaMakeAddin
Application.Dialogs(xlDialogWorkbookName
Application.Dialogs(xlDialogWorkbookNew
Application.Dialogs(xlDialogWorkbook




TODO dialogs args


' Built-In Dialog Box Argument Lists
'  Dialog box constant  Argument list(s)
'
' NOTE:  To Use any of the Dialogs Below -- use the Dialogs() function, thusly:
'
'   With Application.Dialogs(xlDialogActivate)
'         .Show
'   End With
'
' **********************************************************************************************

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



Excel Dialogs TODO dialogs args