setfocus from module to userform control

I have a project with many textboxes on different forms. On some of the textbox_exits on some of the forms, I call a standard module that checks what the user has input . If the user needs to change the input, a msgbox appears to inform the user the info needs to be changed.

I have tried to use ControlSource, Name etc., But I cannot seem to setfocus back onto which ever textbox the input needs to be changed. I think it has something to do wih the _exit event, but not sure.

Any help would be appreciated.

This is the code to call the module

Please Login or Register  to view this content.

this is part of the standard module code

Please Login or Register  to view this content.

The .SetFocus code is working but as soon as the exit routine is exited the focus is returned to the next control.
You need to set the Cancel argument, if appropriate, in the Exit routine.
I have changed your subroutine to a function. This allows you to pass back the require action status.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Alwi please do not hijack threads.

Create a new thread, include a link to any relevant posts.
If your native language is not English I suggest you post in the non-english forum.