
Signature
Bob Buckland ?:-)
MS Office System Products MVP
*Courtesy is not expensive and can pay big dividends*
Hi Bob,
> but it looks like one of the folks here who do more with Word macros may have to create a macro that prompts for the value and that
> macro can then be added separately to either the Quick Access Toolbar ("the" toolbar in Word) or as a Ribbon customization.
OK, here's one that does a very basic validity check (are any shapes selected and is the input value numeric)
Sub Customize3D_Depth()
Dim ThreeDDepth As String
Dim MsgTitle As String
Dim ThreeD_Default As Variant
MsgTitle = "Custom 3D-Depth"
ThreeD_Default = 18
If Selection.ShapeRange.Count > 0 Then
ThreeDDepth = InputBox( _
"Enter Depth for selected Shapes", _
MsgTitle, ThreeD_Default)
If Not IsNumeric(ThreeDDepth) Then
MsgBox "You must enter a valid number!", _
vbOKOnly + vbCritical, MsgTitle
Exit Sub
End If
Selection.ShapeRange.ThreeD.Depth = Val(ThreeDDepth)
Else
MsgBox "No Shapes are selected.", _
vbOKOnly + vbCritical, MsgTitle
End If
End Sub
Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)
http://www.word.mvps.org
This reply is posted in the Newsgroup; please post any follow question or reply in the newsgroup and not by e-mail :-)
Bob Buckland ?:-) - 27 Nov 2006 08:07 GMT
Hi Cindy,
Thank you, that's helpful to fill in that 'blank' (or actually the *lack* of a blank to fill in <g>) for that dialog.
===========
Hi Bob,
> but it looks like one of the folks here who do more with Word macros may have to create a macro that prompts for the value and that
> macro can then be added separately to either the Quick Access Toolbar ("the" toolbar in Word) or as a Ribbon customization.
OK, here's one that does a very basic validity check (are any shapes selected and is the input value numeric)
Sub Customize3D_Depth()
Dim ThreeDDepth As String
Dim MsgTitle As String
Dim ThreeD_Default As Variant
MsgTitle = "Custom 3D-Depth"
ThreeD_Default = 18
If Selection.ShapeRange.Count > 0 Then
ThreeDDepth = InputBox( _
"Enter Depth for selected Shapes", _
MsgTitle, ThreeD_Default)
If Not IsNumeric(ThreeDDepth) Then
MsgBox "You must enter a valid number!", _
vbOKOnly + vbCritical, MsgTitle
Exit Sub
End If
Selection.ShapeRange.ThreeD.Depth = Val(ThreeDDepth)
Else
MsgBox "No Shapes are selected.", _
vbOKOnly + vbCritical, MsgTitle
End If
End Sub
Cindy Meister >>

Signature
Bob Buckland ?:-)
MS Office System Products MVP
*Courtesy is not expensive and can pay big dividends*
Cindy M. - 28 Nov 2006 14:29 GMT
Hi Bob,
> Thank you, that's helpful to fill in that 'blank' (or actually the *lack* of a blank to fill in <g>) for that dialog.
You're welcome :-)
Cindy Meister