View Single Post
 
Old 09-19-2018, 03:46 PM
trevorc trevorc is offline Windows 7 32bit Office 2013
Competent Performer
 
Join Date: Jan 2017
Posts: 173
trevorc will become famous soon enoughtrevorc will become famous soon enough
Default

I just found this snippet, I'll play around with this for a while, the button moves with respect to the current cursor position, I may be able to improve on this later.

Code:
Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
With ActiveSheet.Shapes("sortAZ")
    .Top = Target.Offset(1).Top
    .Left = Target.Offset(, 1).Left
End With
...
Reply With Quote