Make Userform Caption equal textbox contents

  • Thread starter Thread starter Roger on Excel
  • Start date Start date
R

Roger on Excel

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

Can anyone help?

Thanks,

Roger
 
You can try

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

or you can use Textbox1_Exit event...
 
Thanks Jacob - works nicely

Roger

Jacob Skaria said:
You can try

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

or you can use Textbox1_Exit event...
Click to expand...
 
Back
Top