everytime see commondbutton on the screen

[bskaa]

Hi all,
I had added a commandbutton for working a userform in my excel sheet. When the data increase, I have to study at lower rows. However the commondbutton is at the top rows. I can not see the button. Everytime I have to go top of page for working the commandbutton. Can I see the commandbutton whichever cells I study.
Could you help me please?

[MickG]

One possible way:-
Right click in column 1 and the commadbutton will be aligned in the same row'

Private Sub Worksheet_BeforeRightClick(ByVal Target As Range, Cancel As Boolean)
If Target.Column = 1 And Target.Count = 1 Then
    Cancel = True
    CommandButton1.Top = ActiveCell.Top
End If
End Sub

[bskaa]

thank you alot.

[MickG]

You're welcome
Regrds Mick

[Alf]

Did not check and see that OP already got a perfekt answer to the problem. My message deleted.

Alf