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




Custom Search