View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Rech Jim Rech is offline
external usenet poster
 
Posts: 2,718
Default Snap Object to cell borders

"Snapping" is accomplished by adjusting an object's Top and Left properties
to those of the underlying cell:

Dim x As Shape
Set x = Sheet1.Shapes(1)
x.Left = x.TopLeftCell.Left
'etc

No way to link the moving of objects. You'd have to write a macro to do
that.

--
Jim
"Ed Schwartz" wrote in message
...
|
| I'm writing an application where users will move around several
| objects (Label fields) on a worksheet
|
| 1. How can I make the objects "snap" to the cell borders ?
| 2. Is it possible to "link" two or more objets (on different worksheets)
| so that all "linked" objects are moved simultaneously if one of them
| is moved?
|
| Thanks a lot for any ideas or suggestions !
|
| Ed
|