Macro Sheets Only
Equivalent to choosing the Patterns tab in the Format Cells dialog box, which appears when you choose the Cells command from the Format menu. Changes the appearance of the selected cells or objects or the selected chart item (you can select only one chart item at a time). The PATTERNS function has eight syntax forms: syntax 1 is for cells on a sheet or macro sheet. Syntax 2 is for lines or arrows on a worksheet, macro sheet, or chart. Syntax 3 is for objects on a sheet or macro sheet. Syntax 4 through syntax 8 are for chart items.
Syntax 1
Cells
PATTERNS(apattern, afore, aback, newui)
PATTERNS?(apattern, afore, aback, newui)
Syntax 2
Lines (arrows) on worksheets or charts
PATTERNS(lauto, lstyle, lcolor, lwt, hwidth, hlength, htype)
PATTERNS?(lauto, lstyle, lcolor, lwt, hwidth, hlength, htype)
Syntax 3
Text boxes, rectangles, ovals, arcs, and pictures on worksheets or macro sheets
PATTERNS(bauto, bstyle, bcolor, bwt, shadow, aauto, apattern, afore, aback, rounded, newui)
PATTERNS?(bauto, bstyle, bcolor, bwt, shadow, aauto, apattern, afore, aback, rounded, newui)
Syntax 4
Chart plot areas, bars, columns, pie slices, and text labels
PATTERNS(bauto, bstyle, bcolor, bwt, shadow, aauto, apattern, afore, aback, invert, apply, new_fill)
PATTERNS?(bauto, bstyle, bcolor, bwt, shadow, aauto, apattern, afore, aback, invert, apply, new_fill)
Syntax 5
Chart axes
PATTERNS(lauto, lstyle, lcolor, lwt, tmajor, tminor, tlabel)
PATTERNS?(lauto, lstyle, lcolor, lwt, tmajor, tminor, tlabel)
Syntax 6
Chart gridlines, hi-lo lines, drop lines, lines on a picture line chart, and picture charts of bar and column charts
PATTERNS(lauto, lstyle, lcolor, lwt, apply, smooth)
PATTERNS?(lauto, lstyle, lcolor, lwt, apply, smooth)
Syntax 7
Chart data lines
PATTERNS(lauto, lstyle, lcolor, lwt, mauto, mstyle, mfore, mback, apply, smooth)
PATTERNS?(lauto, lstyle, lcolor, lwt, mauto, mstyle, mfore, mback, apply, smooth)
Syntax 8
Picture chart markers
PATTERNS(type, picture_units, apply)
PATTERNS?(type, picture_units, apply)
The following argument descriptions are in alphabetic order. Arguments correspond to check boxes, list boxes, and options in the Patterns tab of the Format Cells dialog box for the selected item. The default for each argument reflects the setting in the dialog box.
Aauto is a number from 0 to 2 specifying area settings (that is, the object's "surface area").
If aauto is Area settings are
0 Set by the user (custom)
1 Automatic (set by Microsoft Excel)
2 None
Aback is a number from 1 to 56 corresponding to the 56 area background colors in the Patterns tab of the Format Cells dialog box.
Afore is a number from 1 to 56 corresponding to the 56 area foreground colors in the Patterns tab of the Foramt Cells dialog box.
Apattern is a number corresponding to the area patterns in the Patterns tab of the Format Cells or Format Object dialog box. If an object is selected, apattern can be from 1 to 18; if a cell is selected, apattern can be from 0 to 18. If apattern is 0 and a cell is selected, Microsoft Excel applies no pattern.
Apply is a logical value corresponding to the Apply To All check box in Microsoft Excel version 4.0. This argument is for compatibility with previous versions of Microsoft Excel and applies only when a chart data point or a data series is selected.
Bauto is a number from 0 to 2 specifying border settings.
If bauto is Border settings are
0 Set by the user (custom)
1 Automatic (set by Microsoft Excel)
2 None
Bcolor is a number from 1 to 56 corresponding to the 56 border colors in the Border tab of the Format Object or Format (chart element) dialog box.
Bstyle is a number from 1 to 8 corresponding to the eight border styles in the Border tab of the Format Object or Format (chart element) dialog box.
Bwt is a number from 1 to 4 corresponding to the four border weights in the Border tab of the Format Object or Format (chart element) dialog box.
If bwt is Border is
1 Hairline
2 Thin
3 Medium
4 Thick
Hlength is a number from 1 to 3 specifying the length of the arrowhead.
If hlength is Arrowhead is
1 Short
2 Medium
3 Long
Htype is a number from 1 to 5 specifying the style of the arrowhead.
If htype is Style of arrowhead is
1 No head
2 Open head
3 Closed head
4 Double open head
5 Double closed head
Hwidth is a number from 1 to 3 specifying the width of the arrowhead.
If hwidth is Arrowhead is
1 Narrow
2 Medium
3 Wide
Invert is a logical value corresponding to the Invert If Negative check box in the Patterns tab of the Format Data Series dialog box. This argument applies only to data markers.
Lauto is a number from 0 to 2 specifying line settings.
If lauto is Line settings are
0 Set by the user (custom)
1 Automatic (set by Microsoft Excel)
2 None
Lcolor is a number from 1 to 56 corresponding to the 16 line colors in the Patterns tab of the Format Object or Format (chart element) dialog box.
Lstyle is a number from 1 to 8 corresponding to the eight line styles in the Patterns tab of the Format Object or Format (chart element) dialog box.
Lwt is a number from 1 to 4 corresponding to the four line weights in the Patterns tab of the Format Object or Format (chart element) dialog box.
If lwt is Line is
1 Hairline
2 Thin
3 Medium
4 Thick
Mauto is a number from 0 to 2 specifying marker settings.
If mauto is Marker settings are
0 Set by the user
1 Automatic (set by Microsoft Excel)
2 None
Mback is a number from 1 to 56corresponding to the 56 marker background colors in the Patterns tab of the Format Data Series dialog box.
Mfore is a number from 1 to 56 corresponding to the 56 marker foreground colors in the Patterns tab of the Format Data Series dialog box.
Mstyle is a number from 1 to 9 corresponding to the nine marker styles in the Patterns tab of the Format Data Series dialog box.
Picture_units is the number of units you want each picture to represent in a scaled, stacked picture chart. This argument applies only to picture charts and only if type is 3.
Rounded is a logical value corresponding to the Round Corners check box and specifying whether to make the corners on text boxes and rectangles rounded. If rounded is TRUE, the corners are rounded; if FALSE, the corners are square. If the selection is an arc or an oval, rounded is ignored.
Newui is a logical value that specifies whether to use the foreground, background, and patterns of Microsoft Excel 5.0 or later. If TRUE or omitted, the colors and patterns of Microsoft Excel 5.0 or later will be used. If FALSE, the colors and patterns of Microsoft Excel 4.0 will be used.
Newfill is a logical value that specifies whether to use the chart patterns of Microsoft Excel 5.0 or later. If TRUE or omitted, the chart patterns of Microsoft Excel 5.0 or later will be used. If FALSE, the chart patterns of Microsoft Excel 4.0 will be used.
Shadow is a logical value corresponding to the Shadow check box. Shadow does not apply to area charts or bars in bar charts. If shadow is TRUE, Microsoft Excel adds a shadow to the selected item; if FALSE, Microsoft Excel removes the shadow, if one is present, from the selected item. If the selection is an arc, shadow is ignored.
Smooth is a logical value that applies smoothing to picture markers in line or xy (scatter) charts. The default is FALSE.
Tlabel is a number from 1 to 4 specifying the position of tick labels.
If tlabel is Tick label position is
1 None
2 Low
3 High
4 Next to axis
Tmajor is a number from 1 to 4 specifying the type of major tick marks.
If tmajor is Type of major tick marks is
1 None
2 Inside
3 Outside
4 Cross
Tminor is a number from 1 to 4 specifying the type of minor tick marks.
If tminor is Type of minor tick marks is
1 None
2 Inside
3 Outside
4 Cross
Type is a number from 1 to 3 specifying the type of pictures to use in a picture chart.
If type is Pictures should be
1 Stretched to reach a particular value
2 Stacked on top of each other to reach a particular value
3 Stacked on top of each other, but you specify the number of units each picture represents
Remarks
Related Functions
FONT.PROPERTIES Applies a font to the selection
FORMAT.TEXT Formats a text box or a chart text item
List of Command-Equivalent Functions