Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
textbox automation error
Why does this happen and how can I get around it??
Brand new workbook (no data) Create a UserForm (UserForm1) Add a Textbox and a command button. The only code is in the TextBox AfterUpdate Event. Private Sub TextBox1_AfterUpdate() Unload Me End Sub Crashes with an "Automation Error"?? I'm trying to use this scenario in a different workbook and need to close the present userform to open a second one but I can't even get the above to work in a new blank workbook. Any ideas?? Thanks, John |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
textbox automation error
Put it in the exit event.
-- Regards, Tom Ogilvy "John Wilson" wrote in message ... Why does this happen and how can I get around it?? Brand new workbook (no data) Create a UserForm (UserForm1) Add a Textbox and a command button. The only code is in the TextBox AfterUpdate Event. Private Sub TextBox1_AfterUpdate() Unload Me End Sub Crashes with an "Automation Error"?? I'm trying to use this scenario in a different workbook and need to close the present userform to open a second one but I can't even get the above to work in a new blank workbook. Any ideas?? Thanks, John |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
textbox automation error
That worked Tom.
Thanks, John "Tom Ogilvy" wrote in message ... Put it in the exit event. -- Regards, Tom Ogilvy "John Wilson" wrote in message ... Why does this happen and how can I get around it?? Brand new workbook (no data) Create a UserForm (UserForm1) Add a Textbox and a command button. The only code is in the TextBox AfterUpdate Event. Private Sub TextBox1_AfterUpdate() Unload Me End Sub Crashes with an "Automation Error"?? I'm trying to use this scenario in a different workbook and need to close the present userform to open a second one but I can't even get the above to work in a new blank workbook. Any ideas?? Thanks, John |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automation Error | Excel Discussion (Misc queries) | |||
RunTime Error (Automation Error) | Excel Programming | |||
Automation error | Excel Programming | |||
Automation Error, Unknown Error. Error value - 440 | Excel Programming | |||
Unknown where is the problem on the Runtime error - Automation error | Excel Programming |