Userform to Userform

[brentjohn]

Greetings,
I'm using an Userform ("Vendor_ContactsSetUp") to enter information. Textbox tConatctName ("Private Sub tContactName_Exit(ByVal Cancel As MSForms.ReturnBoolean)") can trigger to open another Useform ("Vendor_ContactsName_Use"). I have a CommandButton on this second Useform. If pressed, I want to close this second Userform and return to the first Userform Textbox tConatctName and clear the value.
The following code works to close and clear the value. However, it does not return to Textbox tConatctName, the next Textbox is highlighted.

Please Login or Register  to view this content.

[MikeVol]

Hi @brentjohn. Maybe like this?

Please Login or Register  to view this content.

[brentjohn]

MikeVol,
Thank you for your help. However, it still is going to the next Textbox. I tried changing the Tab order as well.

[romperstomper]

Do you set Cancel = True in the tContactName_Exit routine?

By the way, your forms generally should not unload themselves. Whatever code loaded them should unload them.

[brentjohn]

rorya,
Works perfectly!