Excel Form - Scrollbar and associated field references
 

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.

Excel Form - Scrollbar and associated field references
 

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.

--
Regards,
Tom Ogilvy


"Dennis Witt" <u18063@uwe wrote in message news:5ae2af22ec201@uwe...
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.

Excel Form - Scrollbar and associated field references
 

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.


Dennis Witt wrote:
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.

Excel Form - Scrollbar and associated field references
 

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.

--
Regards,
Tom Ogilvy


"Dennis Witt" <u18063@uwe wrote in message news:5ae352d738739@uwe...
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.


Dennis Witt wrote:
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.