| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| make userform textbox value permanent | Excel Programming | |||
| How to change textbox caption in Active sheet from UserForm | Excel Programming | |||
| How do I make a cell's contents equal to another cell's contents with macro program? | Excel Programming | |||
| How do I print the contents of a textbox that is on a Userform | Excel Programming | |||
| make cell contents equal to null value - not blank, but empty | Excel Worksheet Functions | |||
Hybrid Mode
