Locking CommandButton in UserForm in VBA

[Shodi]

Hi Everyone.
I am trying to write a VBA code where the UserForm resizes dynamically depending on values retrieved from cell counts.

I have worked that out but I need to have the CommandButton locked to the lower right-hand corner of the UserForm so that it can easily be clicked once the data input is over.

Since the UserForm resizes itself (it can become really big depending on the values captured) from a minimum of 1 textbox to possibly 15 columns and 50 rows of textboxes, I cannot have it anywhere in the top or bottom centre (please let me know if I am wrong and this is possible).

The most viable option I feel is to stick it in the lower right corner of the UserForm.

It is possible to have it in the upper left corner (it does remain stationary there) but that feels wrong...based on conventional structure.

Please let me know what can be done.

Thanks

 

[Taul]

Hi,
An alternative idea is to fix the size of your Userform and put your textboxes into a Frame. Then add vertical scroll bars to the frame.

Link here for details of adding the scroll bars to a frame

[RESOLVED] [Excel] Scroll Bars in a Frame-VBForums

Hey everybody! I have a frame which contains 44 labels and 88 text boxes in 44 rows and 3 columns. I want to add a scroll bar to the Vertical (right hand) side. I've never done this before, but from trial and error I assume its not as easy as just setting the ScrollBars Property of the...

www.vbforums.com

 

[Shodi]

Thanks a lot, Taul... That is helpful.