| ダイアログ ボックス定数 | 引数リスト |
|---|---|
| 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 |
サポートとフィードバック
Office VBA またはこの説明書に関するご質問やフィードバックがありますか？ サポートの受け方およびフィードバックをお寄せいただく方法のガイダンスについては、Office VBA のサポートおよびフィードバックを参照してください。