_Chart.DropDowns(Object) Method
Definition
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
For callouts with an explicitly set drop value, this property returns the vertical distance (in points) from the edge of the text bounding box to the place where the callout line attaches to the text box. Read-only Single.
public object DropDowns (object Index);
Public Function DropDowns (Optional Index As Object) As Object
Parameters
- Index
- Object
Returns
Returns Object.
Examples
This example replaces the custom drop for shape one on myDocument with one of two preset drops, depending on whether the custom drop value is greater than or less than half the height of the callout text box. For the example to work, shape one must be a callout.
<span class="label">Set myDocument = Worksheets(1)
With myDocument.Shapes(1).Callout
If .DropType = msoCalloutDropCustom Then
If .</span>
<i>Drop</i>
<span class="label">< .Parent.Height / 2 Then .PresetDrop msoCalloutDropTop Else .PresetDrop msoCalloutDropBottom End If End If End With</span>
This example replaces the custom drop for shape one on myDocument with one of two preset drops, depending on whether the custom drop value is greater than or less than half the height of the callout text box. For the example to work, shape one must be a callout.
<span class="label">Set myDocument = Worksheets(1)
With myDocument.Shapes(1).Callout
If .DropType = msoCalloutDropCustom Then
If .</span>
<i>Drop</i>
<span class="label">< .Parent.Height / 2 Then .PresetDrop msoCalloutDropTop Else .PresetDrop msoCalloutDropBottom End If End If End With</span>
This example replaces the custom drop for shape one on myDocument with one of two preset drops, depending on whether the custom drop value is greater than or less than half the height of the callout text box. For the example to work, shape one must be a callout.
<span class="label">Set myDocument = Worksheets(1)
With myDocument.Shapes(1).Callout
If .DropType = msoCalloutDropCustom Then
If .</span>
<i>Drop</i>
<span class="label">< .Parent.Height / 2 Then .PresetDrop msoCalloutDropTop Else .PresetDrop msoCalloutDropBottom End If End If End With</span>
Remarks
This distance is measured from the top of the text box unless the AutoAttach property is set to True and the text box is to the left of the origin of the callout line (the place that the callout points to), in which case the drop distance is measured from the bottom of the text box.
Use the CustomDrop(Single) method to set the value of this property.
The value of this property accurately reflects the position of the callout line attachment to the text box only if the callout has an explicitly set drop value — that is, if the value of the DropType property is msoCalloutDropCustom.
Applies to
피드백
https://aka.ms/ContentUserFeedback
출시 예정: 2024년 내내 콘텐츠에 대한 피드백 메커니즘으로 GitHub 문제를 단계적으로 폐지하고 이를 새로운 피드백 시스템으로 바꿀 예정입니다. 자세한 내용은 다음을 참조하세요.다음에 대한 사용자 의견 제출 및 보기