Insert an icon relative to the button location

[Armidion]

Hello,

I was wondering if i could get a hand with inserting a file.

Is there a way to insert the file and have it placed a relative distance from the insert button without using cell references?

Thanks.

[Andy Pope]

You could use the TopLeftCell reference of the shape.

You just need to identify which button was clicked. If it's a Forms control you can use Application.Caller it identify it.

If it's a ActiveX button you can use the .Left property

[Armidion]

Thanks for the help Andy