That worked Tom.

Thanks,
John

"Tom Ogilvy" <twogilvy@msn.com> wrote in message
news:%239AOQ0jAFHA.3744@TK2MSFTNGP15.phx.gbl...
> Put it in the exit event.
>
> --
> Regards,
> Tom Ogilvy
>
> "John Wilson" <jwilson@optonline.net> wrote in message
> news:erwJisjAFHA.2792@TK2MSFTNGP15.phx.gbl...
>> 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
>>
>>
>
>