Programming Excel with VBA and .NET

TextBox and RefEdit Members

Use the TextBox control to get text entries from a user. Use the RefEdit control to get a selected range from the user. In addition to the members listed for the general Control object, the TextBox and RefEdit controls have the following members. Key members (shown in bold) are covered in the following reference section:

AutoSize	AutoTab	AutoWordSelect
BackColor	BackStyle	BorderColor
BorderStyle	CanPaste	Copy
CurLine	CurTargetX	CurX
Cut( )	DragBehavior	Enabled
EnterFieldBehavior	EnterKeyBehavior	Font
ForeColor	HideSelection	IMEMode
IntegralHeight	LineCount	Locked
MaxLength	MouseIcon	MousePointer
MultiLine	PasswordChar	Paste
ScrollBars	SelectionMargin	SelLength
SelStart	SelText	SpecialEffect
TabKeyBehavior	Text	TextAlign
TextLength	Value	WordWrap

The TextBox and RefEdit members are a subset of the ComboBox members, so see that object for those topics. See the previous section, "TabStrip Members,” for an example of loading files into a text box and using the MultiLine and ScrollBar properties. Several TextBox and RefEdit members that are not found in the ComboBox control are covered here.