Text property (Microsoft Forms)
object.Text [= String ]
The Text property syntax has these parts:
|object||Required. A valid object.|
|String||Optional. A string expression specifying text. The default value is a zero-length string ("").|
For a TextBox, any value you assign to the Text property is also assigned to the Value property.
For a ComboBox, you can use Text to update the value of the control. If the value of Text matches an existing list entry, the value of the ListIndex property (the index of the current row) is set to the row that matches Text. If the value of Text does not match a row, ListIndex is set to -1.
For a ListBox, the value of Text must match an existing list entry. Specifying a value that does not match an existing list entry causes an error.
You cannot use Text to change the value of an entry in a ComboBox or ListBox; use the Column or List property for this purpose.
The ForeColor property determines the color of the text.
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.