Skip to content

Latest commit

 

History

History
47 lines (29 loc) · 1.17 KB

Excel.ThreeDFormat.PresetLightingDirection.md

File metadata and controls

47 lines (29 loc) · 1.17 KB
Raw
title keywords f1_keywords api_name ms.assetid ms.date ms.localizationpriority
ThreeDFormat.PresetLightingDirection property (Excel)
vbaxl10.chm119010
vbaxl10.chm119010
Excel.ThreeDFormat.PresetLightingDirection
5aea55a7-1718-a741-fc9b-f3e402469651
05/17/2019
medium

ThreeDFormat.PresetLightingDirection property (Excel)

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

[!includeSupport and feedback]