LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default 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.



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Active X Controls Tabbing from Form Field 2 Form Field Tfrup12 Excel Discussion (Misc queries) 0 February 19th 08 08:15 PM
How do I set up excel to tab from field to field in a form? bigmac6365 Excel Discussion (Misc queries) 2 September 30th 05 08:32 PM
scrollbar reslut makes another scrollbar to show Patrik Excel Discussion (Misc queries) 0 April 18th 05 03:11 PM
Non-Functioning Scrollbar in Excel User Form Judy Hopkins Excel Programming 0 November 6th 03 09:00 PM
Add & Delete Records in Excel using a form showing a scrollbar also! eijaz Excel Programming 1 October 26th 03 05:31 PM


All times are GMT +1. The time now is 06:28 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"