Results 1 to 6 of 6

Thread: BUTTONS (2002)

  1. #1
    Star Lounger
    Join Date
    Mar 2005
    Location
    London, Hampshire, United Kingdom
    Posts
    59
    Thanks
    0
    Thanked 0 Times in 0 Posts

    BUTTONS (2002)

    Is there a way to position a button precisely by reference to margins instead of trying to align it by co-ordination of hand and eye with a gridline?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: BUTTONS (2002)

    Hold down the Alt key while moving and resizing a button or other object placed on a worksheet.

  3. #3
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: BUTTONS (2002)

    If the button is on a user form, yes - use the Top and Left properties. If the button is on a worksheet, no, not that I know of.
    Legare Coleman

  4. #4
    2 Star Lounger
    Join Date
    May 2005
    Location
    Wilcox, Saskatchewan
    Posts
    171
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: BUTTONS (2002)

    you could select the button so it in edit mode and align(move) it with the right, left, up, down arrows

    Seaner

  5. #5
    Star Lounger
    Join Date
    Mar 2005
    Location
    London, Hampshire, United Kingdom
    Posts
    59
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: BUTTONS (2002)

    Thank you all - Hans, not for the first time you have hit the nail on the head. Obvious when you think of it. Like most things!

  6. #6
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: BUTTONS (2002)

    Manually you can use Hans' suggestion, with VB you can set the shapes left and top property to that of the cell of interest:

    <pre> Set shp = ActiveSheet.Shapes(1)
    shp.Left = Range("b3").Left
    shp.Top = Range("b3").Top</pre>


    Steve

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •