Image location controlled by ActiveX CheckBox

[thekamel]

Hello everyone,

I am trying to get an image location set by ActiveX CheckBox. For example:

When checked, I want image at
Left: 358.5
Top: 1026.75

When unchecked, I want the image at
Left: 1411.75
Top: 1026.75

I have tried searching for anything that would point me into the right direction but I just cannot find anything. Any help would be greatly appreciated!

 

[davesexcel]

to move a shape you just need where you want the left and top of the shape.

    ActiveSheet.Shapes.Range(Array("Picture 2")).Left = 358.5
    ActiveSheet.Shapes.Range(Array("Picture 2")).Top = 1026.75

 

[thekamel]

to move a shape you just need where you want the left and top of the shape.

    ActiveSheet.Shapes.Range(Array("Picture 2")).Left = 358.5
    ActiveSheet.Shapes.Range(Array("Picture 2")).Top = 1026.75

Thank you! This is working exactly the way I needed!