Make Userform Caption equal textbox contents

R

Roger on Excel

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

Can anyone help?

Thanks,

Roger
 
J

Jacob Skaria

You can try

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

or you can use Textbox1_Exit event...
 
R

Roger on Excel

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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Firing Event in another user form 1
I figured out the issue thank you. 0
How do I set focus (and select text) on a text box on a modeless userform? 0
Copy value of textbox to clipboard for use in another application 5
Code to cut a paragraph that's followed by a table 2
How to enumerate buttons on user form 2
Reset userform? 2
Changing the text of a label on a Userform 1

Top