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
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.
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks