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