How to make scrollbar disappear after clearing textbox?

R

RB Smissaert

Have a textbox on a userform, which will show a vertical scrollbar when the
text exceeds the height of the textbox.
When I clear the textbox in code (Textbox1.Text = "") the scrollbar will
stay visible and only disappears when one of the arrows of the scrollbars is
clicked.
I have tried clearing the scrollbar by sending a mouseclick via API, but it
doesn't seem to work and there must be an
easier way to do this.
Thanks for any advice.

RBS
 
R

RB Smissaert

Figured this out:

With Textbox1
.SetFocus
.SelText = .Text
.Text = ""
End With

RBS
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

textbox scrollbars disappear 3
Print textbox-content possible? 3
textbox scrollbar disappears 3
Scroll Frame after user event 2
Trying to force a vertical scrollbar to the "Bottom". 3
MultiLine TextBox, how to remove vertical scrollbar? 1
To show the whole text in a tooltip text 4
Set focus to textbox after spin-button control is pressed?? 3

Top