More than 5 years have passed since last update.

Excel マクロで画像を移動

Excel
VBA
マクロ
画像
移動

Last updated at 2018-03-26Posted at 2018-03-26

#Excel VBAで画像を移動させる

Sub 右移動()

    Sheet1.Shapes("Picture 2").Left = Sheet1.Shapes("Picture 2").Left + 10
    Sheet1.Shapes("Picture 2").Rotation = 90

End Sub

Sub 左移動()

    Sheet1.Shapes("Picture 2").Left = Sheet1.Shapes("Picture 2").Left - 10
    Sheet1.Shapes("Picture 2").Rotation = -90

End Sub
Sub 上移動()

    Sheet1.Shapes("Picture 2").Top = Sheet1.Shapes("Picture 2").Top - 10
    Sheet1.Shapes("Picture 2").Rotation = 0

End Sub
Sub 下移動()

    Sheet1.Shapes("Picture 2").Top = Sheet1.Shapes("Picture 2").Top + 10
    Sheet1.Shapes("Picture 2").Rotation = 180

End Sub

You get articles that match your needs
You can efficiently read back useful information
You can use dark theme

What you can do with signing up