Moving shapes to the middle left of an active cell

[biznez]

Hi, not sure if this can be done or not but im trying to have Shape "Oval 1" to appear when a cell is selected and move to the middle left of that activecell using vba. Found this code online, however, not exactly what i need but it's a start. Thanks for help

Please Login or Register  to view this content.

[humdingaling]

not sure what exactly you need, you are pretty much there though

it would either be your shape or target and some algebra to work out exactly what you want
just need to tinker with the variables

Please Login or Register  to view this content.

[biznez]

not sure what exactly you need, you are pretty much there though

it would either be your shape or target and some algebra to work out exactly what you want
just need to tinker with the variables

Please Login or Register  to view this content.

Thanks humdingaling. This is exactly what i needed