Microsoft Office Tutorials and References
In Depth Information
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
Search JabSto ::




Custom Search