VBA: Command Button Always at Bottom Right of Form

[KMGIL]

Hi
I have created a dynamic form which will vary in height depending on user selection

I have added a scroll bar so the user can scroll up and down the form

i would like to add a Command button that would always be at the bottom right of form , is there a VBA code which can do this ?

Thanks

kind Regards

Ken

 

[Domenic]

The following code will position the commandbutton at the bottom right of the userform...

    With Me.CommandButton1
        .Left = Me.InsideWidth - .Width - 10
        .Top = Me.InsideHeight - .Height - 10
    End With

Hope this helps!

 

[KMGIL]

Hi Domenic

This is almost there
I have a scroll bar which adjusts the height of the form , so when i enter in the code as per above the Command button is hidden behind some textboxes

Any thoughts of how i can overcome this?

Thanks

ken

 

[Domenic]

Use the scrollbar change event handler to re-position the commandbutton to the bottom right of the userform.