Edit

ThreeDFormat.PresetLightingDirection property (Excel)

  • Article

Returns or sets the position of the light source relative to the extrusion. Read/write MsoPresetLightingDirection.

Syntax

expression.PresetLightingDirection

expression A variable that represents a ThreeDFormat object.

Remarks

You won't see the lighting effects that you set if the extrusion has a wire frame surface.

Example

This example specifies that the extrusion for shape one on myDocument extend toward the top of the shape and that the lighting for the extrusion come from the left.

Set myDocument = Worksheets(1) 
With myDocument.Shapes(1).ThreeD 
 .Visible = True 
 .SetExtrusionDirection msoExtrusionTop 
 .PresetLightingDirection = msoLightingLeft 
End With

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.