okay, hab doch noch etwas dazu gefunden ...
15.11.2018 23:05:57
udo
Anbei eine Beispieldatei :
https://www.herber.de/bbs/user/125420.xlsm
Darin enthaltene Codes :
' ========================================================================================================================================
Function getObjPos(ObjName As String, Optional xPos As Boolean = True)
' ======================================================================================== _
Application.ScreenUpdating = False
' returns position of shape for given shape name optional boolean parameter for x or y - _
position
' x-position is default
' 06-2006 E.Bimczok Beitrag : https://microsoft.public.de.excel.narkive.com/sR9hFc7D/ _
autoformen-objektpositionierung-auslesen
Application.Volatile
Dim myObj As Object
' Set a = ActiveSheet
For Each myObj In ActiveSheet.Shapes
If myObj.Name = ObjName Then
If xPos Then
getObjPos = myObj.Left
Else
getObjPos = myObj.Top
End If
Exit For
End If
Next myObj
Application.ScreenUpdating = True
End Function
' ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Sub verschieben()
' ---------------------------------------------------------------------------------------- _
ActiveSheet.Shapes.Range(Array("Rectangle 1")).Left = [B2].Value
ActiveSheet.Shapes.Range(Array("Rectangle 1")).Top = [B3].Value
' ActiveSheet.Shapes.Range(Array("Rectangle 1")).ScaleWidth = [B3].Value
End Sub
' ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Sub ermitteln()
' ---------------------------------------------------------------------------------------- _
[B2] = getObjPos("Rectangle 1")
[B3] = getObjPos("Rectangle 1", False)
End Sub
' ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Sub Auswahl()
' ---------------------------------------------------------------------------------------- _
Application.ScreenUpdating = False
ActiveSheet.Shapes.Range(Array("Rectangle 1")).Select
Application.ScreenUpdating = True
End Sub
LG udo