Page 417 - Microsoft Office Excel 2003 Programming Inside Out

Part 5: Manipulating Excel Objects
Customizing Dialog Boxes

Table 18-1 lists some of the common dialog boxes used to format cells in the workbook.
Table 18-1. xlDialog Boxes Used to Format Cells
xlDialog Box Description

xlDialogActiveCellFont font, font_style, size, strikethrough, superscript, subscript,
outline, shadow, underline, color, normal, background,
start_char, char_count
xlDialogAlignment horiz_align, wrap, vert_align, orientation, add_indent
xlDialogBorder outline, left, right, top, bottom, shade, outline_color,
left_color, right_color, top_color, bottom_color
xlDialogCellProtection locked, hidden
xlDialogFont name_text, size_num
xlDialogFontProperties font, font_style, size, strikethrough, superscript, subscript,
outline, shadow, underline, color, normal, background,
start_char, char_count
xlDialogFormatFont name_text, size_num, bold, italic, underline, strike, color,
outline, shadow
xlDialogPatterns apattern, afore, aback, newui

Table 18-2 lists some of the common dialog boxes used to insert or modify charts in a
workbook.

Table 18-2. xlDialog Boxes Used to Modify Charts
xlDialog Box Description
xlDialogAddChartAutoformat name_text, desc_text
xlDialogAxes x_primary, y_primary, x_secondary, y_secondary
xlDialogChartAddData ref, rowcol, titles, categories, replace, series
xlDialogChartWizard long, ref, gallery_num, type_num, plot_by, categories,
ser_titles, legend, title, x_title, y_title, z_title, number_cats,
number_titles
xlDialogDataLabel show_option, auto_text, show_key
xlDialogDataSeries rowcol, type_num, date_num, step_value, stop_value, trend
xlDialogEditSeries series_num, name_ref, x_ref, y_ref, z_ref, plot_order
xlDialogFormatChart layer_num, view, overlap, angle, gap_width, gap_depth,
chart_depth, doughnut_size, axis_num, drop, hilo, up_down,
series_line, labels, vary
Chapter 18
continued

391