Textbox enable and set focus

Hi Gurus,

It seems there are tonnes of solutions on how to set focus on certain objects, yet I struggle to find/adapt one to fit my needs.

Assume you have 2 textboxes and command button on a userform, where txtbox1 will be enabled and txtbox2 disabled. Once user keys in anything in txtbox1, txtbox2 is being enabled using afterupdate event but focus is set on command button even it is out of tab index order.

Question: how do I set focus on txtbox2 when I tab out of txtbox1..?

A million thanks.

Hi and sorry for a late reply. I have already tried this before and no luck. Basically within one sub I need to enable txtbox2 and set focus to it.

This is a simple dummy code:

Please Login or Register  to view this content.

This will still set focus on a command button when tabbing out of txtbox1.

The actual userform contains of course more than 2 textboxes as well as bunch of other objects, but that doesn't change anything. The actual code is similar to the one above. I don't know what else to try...

Anybody? Please?