| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
setting userform-screen fit
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 ? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
setting userform-screen fit
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: 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 ? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
setting userform-screen fit
You can use a multi page control to group and separate the fields.
NickHK "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 ? |
|
#4
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 ? |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
setting userform-screen fit
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 ? " wrote: 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: 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 ? |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
setting userform-screen fit
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" wrote: 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 ? |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
setting userform-screen fit
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 "TUNGANA KURMA RAJU" wrote in message ... 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" wrote: 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 ? |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
setting userform-screen fit
Thanks,Your help is highly appreciated.
"Peter T" wrote: 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 "TUNGANA KURMA RAJU" wrote in message ... 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" wrote: 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 ? |
| Reply |
| 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 | |||
Linear Mode
