Make Userform Caption equal textbox contents

[Roger on Excel]

How does one make a Userform title bar caption Equal the contents of Textbox1?

Can anyone help?

Thanks,

Roger

 

[Jacob Skaria]

You can try

Private Sub TextBox1_Change()
UserForm1.Caption = TextBox1.Text
End Sub

or you can use Textbox1_Exit event...

 

[Roger on Excel]

Thanks Jacob - works nicely

Roger

You can try

Private Sub TextBox1_Change()
UserForm1.Caption = TextBox1.Text
End Sub

or you can use Textbox1_Exit event...