setting userform-screen fit
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
"TUNGANA KURMA RAJU" wrote in
message ...
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 ?
|