Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Clearing a textbox in userform
The user fills in Textbox 40 in Userform7, then clicks a CMD button to
execute a macro, which brings up UserForm11 for the user to interact with. UF7 stays up during this, because he will need to continue with another function within that UserForm. So, when the user is done with UF11, UF7 is still there for him to continue with. Is there a way for Textbox40 to be cleared when it comes back? I can't unload, then reload it, since there will be other textboxes in UF7 with data that will need to be processed later on. I have this change event code for the textbox now. Private Sub TextBox40_Change() EditPOVal = TextBox40.Value End Sub I've tried putting TextBox40.Text = "" in various places, but it doesn't react correctly. Any suggestions? Thanks, J.O. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Clearing a textbox in userform
In the commandbutton code, after the Userform11 show
UF11.Show TexBox40.Text = "" -- HTH Bob Phillips (remove nothere from email address if mailing direct) "excelnut1954" wrote in message oups.com... The user fills in Textbox 40 in Userform7, then clicks a CMD button to execute a macro, which brings up UserForm11 for the user to interact with. UF7 stays up during this, because he will need to continue with another function within that UserForm. So, when the user is done with UF11, UF7 is still there for him to continue with. Is there a way for Textbox40 to be cleared when it comes back? I can't unload, then reload it, since there will be other textboxes in UF7 with data that will need to be processed later on. I have this change event code for the textbox now. Private Sub TextBox40_Change() EditPOVal = TextBox40.Value End Sub I've tried putting TextBox40.Text = "" in various places, but it doesn't react correctly. Any suggestions? Thanks, J.O. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Clearing a textbox in userform
Thanks Bob.
I've been searching past posts off and on all day.... and as happens, I stumbled on a solution after I posted this. Same as yours. Works fine. I appreaciate your quick response. Thanks again, J.O. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to make scrollbar disappear after clearing textbox? | Excel Programming | |||
Clearing a userform | Excel Programming | |||
userform textbox | Excel Worksheet Functions | |||
Textbox in userform | Excel Programming | |||
UserForm TextBox to ActiveSheet TextBox over 256 characters | Excel Programming |