Make Userform Caption equal textbox contents
 

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

Can anyone help?

Thanks,

Roger

Make Userform Caption equal textbox contents
 

You can try

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

or you can use Textbox1_Exit event...

--
Jacob


"Roger on Excel" wrote:

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

Can anyone help?

Thanks,

Roger

Make Userform Caption equal textbox contents
 

Thanks Jacob - works nicely

Roger

"Jacob Skaria" wrote:

You can try

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

or you can use Textbox1_Exit event...

--
Jacob


"Roger on Excel" wrote:

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

Can anyone help?

Thanks,

Roger