VBA - How to make the text box initially show the first part of the text?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Frank Krogh (frank.krogh_at_sintef.no)
Date: 03/31/04 

Date: Wed, 31 Mar 2004 11:32:36 +0200

I have written som help text in a text box control in a userform. The text
box has a vertical scrollbar to show all the text.

First I position the cursor in the beginning of the text and then set the
Locked property to false.

Then I run the userform with the myUserform.show, but it only shows the last
part of the text I have entered in the text box.

How do I make the text box show the beginning of the text?

How do I print the text in a text box when it covers more than what is
visible in the text box area?

Thanks for suggestions.

Frank Krogh

Relevant Pages

  • VBA stealing keys from ActiveX control?
    ... It appears that a UserForm displayed from VBA is stealing keystrokes from one ... Normal alphanumeric keys work fine. ... We have a VB application that launches the VBA IDE. ... Another button on the VB application launches an MFC C++ ActiveX control. ...
    (microsoft.public.vb.general.discussion)
  • Re: Sum and Counta function in Listbox for UserForm
    ... You can link the cell to the UserForm control by setting the ControlSource property of the control, either in the object properties within VB Editor or in code within the UserForm. ... Private Sub UserForm_Initialize ...
    (microsoft.public.excel.programming)
  • Re: Code for Back Tab
    ... Say you had a control on your form into which the patient's name was added ... those fields from the userform if the user has updates later. ... re-protected the template, saved, and opened the template from New. ... command button to populate the form and I get an Error 4605. ...
    (microsoft.public.word.vba.userforms)
  • Re: Actions between user actions
    ... These problems seemed to go away when I started disabling the UserForm ... it during a series of events related to one control, ... UserForm both ensures that the OnTime event fires right away after the ...
    (microsoft.public.excel.programming)
  • Re: Preview an auto-text entry in a user form
    ... I've a userform and RTF control no problem and a Cmd Button. ... Set rngAuto = ActiveDocument.Range ...
    (microsoft.public.word.vba.userforms)