User form question

  • Thread starter Thread starter nath
  • Start date Start date
N

nath

hello

i have a user form in excel that builds itself (text boxes
visible on/off) based upon the fields within an access
table. However there are 47 text boxes. Is there a way
that i can show only 15 or so, and use the scroll bar to
scroll down for the rest?

TIA

Nath
 
User Forms, Frames and Multi Pages support scroll bars.
Select this option from the Properties list. To view this
list, first activate the object and right click.

You'll probably want the fmScrollBarsVertical option. You
must also set a ScrollHeight greater than the height of
the container object, whatever is required to allow
veiwing of all text boxes.

Regards,
Greg
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Tricky user form question 1
Force Scroll Bar Down on TextBox Control 5
Scroll Bars on Worksheet 1
User form controls add 1
Text Box Scroll Bars do not appear until you click in the text box 3
Long User Form Question. 2
Showing text on A Userform 2
Floating List Box 1

Back
Top