regain focus on a userform

[david90]

I have a userform and it occasionally loses focus because of other programs in the background. How do I pro grammatically regain focus?

I have tried to use the focus method for sheet1 and workbook object but both failed to regain focus. Surprisingly the userform doesn't have a focus method.

[Leith Ross]

Hello david90,

Is your user form a worksheet or a VBA UserForm?

[david90]

it's a vba form.

[Leith Ross]

Hello david90,

I am not really sure what you have done here. My guess is the UserForm Is displayed as non-modal. Otherwise, Excel would have to lose focus to another application before the UserForm would lose focus. The other puzzling piece is how is another application taking the focus if you have not switched to by clicking its window?

A UserForm can be given the focus by it being displayed as non-modal and using the Windows API to set the focus to UserForm window. But this would have to be a macro run from the VBIDE and if the workbook does not have the focus then how can you run this macro?

[david90]

Hi,

To clarify, my excel workbook has a userform that was created with the VBIDE. The userform's showmodal property is set to false to make it a non-modal window.

On occasion, the userform would lose focus because I would click on other MS programs and forget to click on the userform again give it focus. My userform needs to have focus in order for it to work properly (the reason for this is not important in this discussion).

I'm aware of the windows api that can be used to give my userform focus but are there any built in vba function that have the same function?

[Leith Ross]

Hello david90,

Other than the user clicking the UserForm or one its controls, no there is not.