Excel Form - Scrollbar and associated field references

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Dennis Witt - 25 Jan 2006 13:10 GMT

Can you provide me with a coding example? I would like to add a scroll bar
to a form with multiple fields tied to the scrollbar. How would l code the
field references? Thank you.

Reply to this Message

Tom Ogilvy - 25 Jan 2006 14:07 GMT

What does that mean - multiple fields tied to the scroll bar. What do you
consider a field? does form mean userform? Most controls on a userform
have the option to display scrollbars if it is meaningful.

Signature

Regards,
Tom Ogilvy

> Can you provide me with a coding example? I would like to add a scroll bar
> to a form with multiple fields tied to the scrollbar. How would l code the
> field references? Thank you.

Reply to this Message

Dennis Witt - 25 Jan 2006 14:23 GMT

Thank you Tom.

My attempt is to create a user form that would included multiple text boxes
controlled by a scroll bar. The data in the text boxes will be populated
from an Oracle database. Multiple rows will be produced and my goal is to
provide a form for editting the data in the text boxes and a scroll to
provide a means of browsing row by row through the data.

I see that the control source properties for a scroll bar and text boxes are
significant to making this happen. I'm not sure on how to define and link
this together.

Maybe my approach is incorrect. I appreciate your input. Thanks again.

>Can you provide me with a coding example? I would like to add a scroll bar
>to a form with multiple fields tied to the scrollbar. How would l code the
>field references? Thank you.

Reply to this Message

Tom Ogilvy - 25 Jan 2006 14:46 GMT

Use the built in textbox scrollbar.

in the textbox properties
change multiline to True
change wordwrap to True
change scrollbars to fmScrollBarsVertical

If the text exceeds the visible area of the box, the Vertical scrollbar will
appear.

I don't believe you even have the properties necessary to control scolling
of the textbox from external to the textbox - so use the built in
capabilities.

Signature

Regards,
Tom Ogilvy

> Thank you Tom.
>
[quoted text clipped - 13 lines]
> >to a form with multiple fields tied to the scrollbar. How would l code the
> >field references? Thank you.

Reply to this Message