| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 ? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Setting hyperlinked cells to be displayed at the top of the screen | Excel Discussion (Misc queries) | |||
| setting of screen zoom in excel | Excel Discussion (Misc queries) | |||
| freeze screen (userform) | Excel Programming | |||
| Screen Updates on a userform | Excel Programming | |||
| Userform Screen Location | Excel Programming | |||
Threaded Mode
