Format related procedures in class Point (Word VBA)

This page presents procedures from class Point related to the theme Format: ClearFormats, Format, MarkerBackgroundColor, MarkerBackgroundColorIndex, MarkerForegroundColor, MarkerForegroundColorIndex and MarkerStyle

ClearFormats

Clears the formatting of the object.

Dim pnt As Point: Set pnt =  
pnt.ClearFormats

Format

Returns the line, fill, and effect formatting for the object.

Dim pnt As Point: Set pnt =  
Dim cftFormatted As ChartFormat
Set cftFormatted = pnt.Format

MarkerBackgroundColor

Sets the marker background color as an RGB value or returns the corresponding color index value.

This property applies only to line, scatter, and radar charts.

With ActiveDocument.InlineShapes(1) 
 If .HasChart Then 
 With .Chart.SeriesCollection(1).Points(2) 
 ' Set the background color to green. 
 .MarkerBackgroundColor = RGB(0,255,0) 
 
 ' Set the foreground color to red. 
 .MarkerForegroundColor = RGB(255,0,0) 
 End With 
 End If 
End With 

MarkerBackgroundColorIndex

Returns or sets the marker background color as an index into the current color palette, or as one of the following XlColorIndex constants: xlColorIndexAutomatic or xlColorIndexNone.

Possible Values are xlColorIndexAutomatic - Automatic color, xlColorIndexNone - No color.

The property applies only to line, scatter, and radar charts.

With ActiveDocument.InlineShapes(1) 
 If .HasChart Then 
 With .Chart.SeriesCollection(1).Points(2) 
 ' Set the background color to green. 
 .MarkerBackgroundColorIndex = 4 
 
 ' Set the foreground color to red. 
 .MarkerForegroundColorIndex = 3 
 End With 
 End If 
End With 

MarkerForegroundColor

Sets the marker foreground color as an RGB value or returns the corresponding color index value.

This property applies only to line, scatter, and radar charts.

With ActiveDocument.InlineShapes(1) 
 If .HasChart Then 
 With .Chart.SeriesCollection(1).Points(2) 
 ' Set the background color to green. 
 .MarkerBackgroundColor = RGB(0,255,0) 
 
 ' Set the foreground color to red. 
 .MarkerForegroundColor = RGB(255,0,0) 
 End With 
 End If 
End With 

MarkerForegroundColorIndex

Returns or sets the marker foreground color as an index into the current color palette, or as one of the following XlColorIndex constants: xlColorIndexAutomatic or xlColorIndexNone.

Possible Values are xlColorIndexAutomatic - Automatic color, xlColorIndexNone - No color.

This property applies only to line, scatter, and radar charts.

With ActiveDocument.InlineShapes(1) 
 If .HasChart Then 
 With .Chart.SeriesCollection(1).Points(2) 
 ' Set the background color to green. 
 .MarkerBackgroundColorIndex = 4 
 
 ' Set the foreground color to red. 
 .MarkerForegroundColorIndex = 3 
 End With 
 End If 
End With 

MarkerStyle

Returns or sets the marker style for a point or series in a line chart, scatter chart, or radar chart.

Possible Values are xlMarkerStyleAutomatic - Automatic markers, xlMarkerStyleCircle - Circular markers, xlMarkerStyleDash - Long bar markers, xlMarkerStyleDiamond - Diamond-shaped markers, xlMarkerStyleDot - Short bar markers, xlMarkerStyleNone - No markers, xlMarkerStylePicture - Picture markers, xlMarkerStylePlus - Square markers with a plus sign, xlMarkerStyleSquare - Square markers, xlMarkerStyleStar - Square markers with an asterisk, xlMarkerStyleTriangle - Triangular markers, xlMarkerStyleX - Square markers with an X.
Dim pnt As Point: Set pnt =  
pnt.MarkerStyle = xlMarkerStyleAutomatic