UserForm's Command button moves when using scrollbar

Hi,

In excel vba, I have a userform with a typical OK command button to which I dynamically add (from left to right) several textboxes. When the number of textboxes are such that their total width is superior to the width of the form, I activate the form's horizontal scroll bar and set the ScrollWidth so the textboxs can all be visible and/or accessed by the user using the horizontal scroll bar at the bottom of the userform. My only problem is that the OK command button also moves when I use the scroll bar.

Is there any technics I could use, vba or otherwise, to freeze the command button position to a specific position on the userform while the user use the horizontal scrollbar ?

Thank You very much for your help
Sylvain

Add a Frame control to your userform with the Textboxes added inside the frame and the Command Button outside. The Frame can have its own horizontal scroll bar that won't affect anything outside.

Scroll Bars in a Frame

lol why didn't I think of that, it's a great idea ! Thank you a thousand times. Much appreciated

Sylvain