+ Reply to Thread
Results 1 to 17 of 17

Can a Command Button's position be kept moving along the TargetCell ROW in the same Column

Hybrid View

  1. #1
    Forum Expert DGagnon's Avatar
    Join Date
    02-23-2012
    Location
    Ontario, Canada
    MS-Off Ver
    Excel 2003, 2007
    Posts
    1,645

    Re: Can a Command Button's position be kept moving along the TargetCell ROW in the same Co

    you could use a code like this, but you will need to adjust the numbers to make it match your row heights

    Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    ActiveSheet.Shapes("Button 1").Top = 15 * Target.Row - 15
    End Sub
    If you liked my solution, please click on the Star -- to add to my reputation

    If your issue as been resolved, please clearly state so and mark the thread as [SOLVED] using the thread tools just above the first post.

  2. #2
    Registered User
    Join Date
    11-03-2008
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    2,521

    Re: Can a Command Button's position be kept moving along the TargetCell ROW in the same Co

    Ok No issues Dave,

    I shall start a new thread but please do help me on that..

    I will link this thread to the new one..

    Warm REgards
    e4excel
    Thanks once again for your help Dave adn Dgagnon

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1