Page 418 - Microsoft Office Excel 2003 Programming Inside Out

Part 5: Manipulating Excel Objects
Microsoft Office Excel 2003 Programming Inside Out

Table 18-2. xlDialog Boxes Used to Modify Charts (continued)
xlDialog Box Description
xlDialogFormatCharttype apply_to, group_num, dimension, type_num
xlDialogFormatLegend position_num
xlDialogGallery3dBar type_num
xlDialogGallery3dColumn type_num
xlDialogGallery3dLine type_num
xlDialogGallery3dPie type_num
xlDialogGalleryDoughnut type_num, delete_overlay
xlDialogGalleryLine type_num, delete_overlay
xlDialogGalleryPie type_num, delete_overlay
xlDialogMainChartType type_num

Table 18-3 lists some of the common dialog boxes used to access a variety of options available
using Excel’s menu structure.

Table 18-3. xlDialog Boxes Found in Excel’s Menu Structure
xlDialog Box Description
xlDialogApplyNames name_array, ignore, use_rowcol, omit_col, omit_row,
order_num, append_last
xlDialogAutoCorrect correct_initial_caps, capitalize_days
xlDialogColorPalette file_text
xlDialogColumnWidth width_num, reference, standard, type_num, standard_num
xlDialogCreateNames top, left, bottom, right
xlDialogDefineName name_text, refers_to, macro_type, shortcut_text, hidden,
category, local
xlDialogDefineStyle style_text, number, font, alignment, border, pattern,
protection
xlDialogFilterAdvanced operation, list_ref, criteria_ref, copy_ref, unique
xlDialogGoalSeek target_cell, target_value, variable_cell
xlDialogInsertObject object_class, file_name, link_logical, display_icon_logical,
icon_file, icon_number, icon_label
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

Chapter 18

392