SNAP shape to position

spacebouncer

Board Regular
Joined
Feb 7, 2014
Messages
109
My program creates some rectangular shapes. The user will need to be able to move these shapes to appropriate positions.

Ideally, I'd like a way to facilitate these coming together neatly, no gaps or overlaps etc.

Obviously not what Excel was built for, but it would be great if this was possible.

I'm thinking two things:

Unlikely - Some way to limit movement to snap as if on a grid, rather than being able to drag to any position.

More likely and perhaps a long bit of coding:
For each shape
Look at the top left position of the corner
If any other top left corners has similar horizontal position, then align.


Any thoughts anyone has on this would be appreciated!
 

Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)
I seem to have immediately answered my own question!

I typed snap into the tags and have now realised that Excel does have this!

No such thing as a silly question!
 
Upvote 0

Forum statistics

Threads
1,223,228
Messages
6,170,871
Members
452,363
Latest member
merico17

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top