Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 112
Default Scroll Bars in TextBox on UserForm

Excel 2003

I have a UserForm with several text boxes on it. The contents of the
text boxes is read from cells in the worksheet with a vba statement
such as:

TextBox8.Text = Cells(n, m).Value

The text boxes have scroll bars enabled with a vba statement

TextBox8.ScrollBars = fmScrollBarsBoth

The text boxes are multi-line and wrapping is enabled.

When the text read into the text box overflows the box, the vertical
scroll bar does not appear immediately. It appears only after the
user clicks the mouse inside the text box. And then when the user
does that, the text in the text box "jumps" (moves vertically) in an
apparently unpredictable manner.

The user is simply reading the text in the cell, not editing it. How
can I get the scroll bar to appear immediately when the text read into
the text box overflows the box? And the user can then just use the
scroll bar to read the rest of the text when he has read to the bottom
of the visible text in the box.
Reply
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
scroll bars Cutearmychic Excel Worksheet Functions 1 August 22nd 08 08:53 PM
SCROLL BARS GSB Excel Discussion (Misc queries) 1 September 28th 07 05:03 PM
Scroll bars Tazzy via OfficeKB.com Excel Discussion (Misc queries) 3 December 10th 06 10:28 PM
Userform and scroll bars KimberlyC Excel Programming 3 April 2nd 04 04:40 PM
UserForm TextBox to ActiveSheet TextBox over 256 characters Dan E[_2_] Excel Programming 1 July 28th 03 07:36 PM


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

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

About Us

"It's about Microsoft Excel"