View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Peter T Peter T is offline
external usenet poster
 
Posts: 5,600
Default 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 ?