Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to get autoscroll in a multiline textbox?
Hi all.
I'd like add to my application a locked textbox where i show what the user does (example: You have added x value, You have modified y parameter etc). My text box has the multiline property set to true and the scrollbars set to VerticalScrollBar. Unfortunately the bar appears only if the textbox get the focus but in this case also I don't get the automatic 1 row up scrolling. The effect I want is what of end titles of a movie. Hoping my explanation be clear wait your suggestions or advices. Thank you in advance. Nicola |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to get autoscroll in a multiline textbox?
Hi Nicola,
In XL2003 I have created this: Option Explicit Private Sub Worksheet_Change(ByVal target As Range) txtLog.Text = txtLog.Text & vbNewLine & "Value of " & _ target.Address & " changed into " & target.Value GotoLastLine target End Sub Private Sub Worksheet_SelectionChange(ByVal target As Range) txtLog.Text = txtLog.Text & vbNewLine & "Selection changed to " & target.Address GotoLastLine target End Sub Private Sub GotoLastLine(target As Range) Application.EnableEvents = False txtLog.Activate txtLog.CurLine = (txtLog.LineCount - 1) target.Select Application.EnableEvents = True End Sub HTH, Wouter |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Textbox and multiline text | Excel Worksheet Functions | |||
Editing multiline textbox | Excel Programming | |||
Multiline textbox for data entry | Excel Programming | |||
Userform Textbox multiline Vs format in worksheet | Excel Programming | |||
Multiline textbox.. Can you have multiple font colors within? | Excel Programming |