setting userform-screen fit

[Guest]

I have about 27 fields to be inserted in userform for updation with
texboxes.The user form I created is long in size.Is it possible to resize it
by inserting these text boxes in a list box with vertical scroll bar ?. How
to create user form for the above task and code ?

 

[halimnurikhwan]

Hi Raju,

May be you can more specific, so someone else
easily know what you mean.
I mean reexplain your problem.

thanks,
halim

TUNGANA KURMA RAJU menuliskan:

 

[NickHK]

You can use a multi page control to group and separate the fields.

NickHK

 

[Peter T]

You can't put controls in a listbox.

Add a vertical Scrollbar (Scrollbars - 2) and set ScrollHeight to suit.
You can apply the scroll bar either to the form to a Frame containing your
textboxes.

Or do you mean use a listbox as your means of data entry. That would be
viable with say a two column listbox (field, data) and a single textbox.
Change events in each to update the other.

Regards,
Peter T

 

[Guest]

Thank you,With 27 text boxes vertically my userform is long enough,does not
fit my desktop screen.Only five text boxes are visible always.Can my user
form be set small size ? Is there any method to scroll the text boxes using
scrol bar ?

 

[Guest]

Thank you,I am a novice to user forms.What you said is correct ,I added a
frame to my user form added all 27 text boxes,but after adding a scroll bar
,it has stuck up .What went wrong

 

[Peter T]

Are you sure you put your textboxes 'in' the frame and not merely over it.

Drag your original userform into a new workbook.
Make the form as large as necessary to fit all the textboxes (even if it
means scrolling down in the VBE)

Add a frame control and size it to fit all the textboxes.
Select all the textboxes and Cut
Select the frame (handles appear)
Paste the textboxes
(ensure the frame has handles when you put controls into it)
Note the height of the frame that allows all textboxes visible.
Resize the Frame and the form to suit
Select the frame
Add the vertical scrollbar and set the scrollheight property you noted
earlier.

Comment all code in the form module
press F5

Regards,
Peter T

 

[Guest]

Thanks,Your help is highly appreciated.

Are you sure you put your textboxes 'in' the frame and not merely over it.

Drag your original userform into a new workbook.
Make the form as large as necessary to fit all the textboxes (even if it
means scrolling down in the VBE)

Add a frame control and size it to fit all the textboxes.
Select all the textboxes and Cut
Select the frame (handles appear)
Paste the textboxes
(ensure the frame has handles when you put controls into it)
Note the height of the frame that allows all textboxes visible.
Resize the Frame and the form to suit
Select the frame
Add the vertical scrollbar and set the scrollheight property you noted
earlier.

Comment all code in the form module
press F5

Regards,
Peter T