Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
VBA updating text box label
- Thread starter PL01
- Start date
The label is a control in it's own right with a name.
Simply reference it like any other control and the property you want to set is 'Caption'
"In complete darkness we are all the same, it is only our knowledge and wisdom that separates us, don't let your eyes deceive you."
"If a shortcut was meant to be easy, it wouldn't be a shortcut, it would be the way!"
Free Electronic Dance Music
Simply reference it like any other control and the property you want to set is 'Caption'
"In complete darkness we are all the same, it is only our knowledge and wisdom that separates us, don't let your eyes deceive you."
"If a shortcut was meant to be easy, it wouldn't be a shortcut, it would be the way!"
Free Electronic Dance Music
Are those controls on a UserForm?
"text box label" - there is a text box and there is a label.
Text box has Text property, label has a Caption property.
[tt]
txtMyTextBox.Text = "I am a Text Box"
lblMyLabel.Caption = "I am a label"
[/tt]
Have fun.
---- Andy
A bus station is where a bus stops. A train station is where a train stops. On my desk, I have a work station.
"text box label" - there is a text box and there is a label.
Text box has Text property, label has a Caption property.
[tt]
txtMyTextBox.Text = "I am a Text Box"
lblMyLabel.Caption = "I am a label"
[/tt]
Have fun.
---- Andy
A bus station is where a bus stops. A train station is where a train stops. On my desk, I have a work station.
- Status
