Maybe this is a stupid answer but i can not completely place your problem.

If you set the focus because you want to get out a value of the textbox with the .text property, this might be a solution.

Use the .value instead of the .text property in VBA, this way you do not have to set the focus to the control to get out the content.

Greetings,