Highlight A Textbox For User Reentry After Incorrect Entry

I've sought out answers to this question many times, and have found solutions, but they didn't appear to work in my case. I think, unproven, the showmodal property of a userform has an effect on the success of many of the readily available solutions found through searches. (involving setfocus and complex selection formula)

I have a userform. The user enters a value in a textbox (tab position 2). A beforeupdate event triggers and checks the appropriateness of the data entered into the textbox by the user.
If an inappropriate entry is identified, the user is notified, and the offending entry is overwritten with a default value. The user is then able to re-enter another value.

As it works now, after the entry is replaced with the default, the highlighting of the textbox awaiting data entry is at the next textbox in tabular order. (tab order 3).

How can I keep the the selection highlighting in the original field (tab order 2) after the correction is made rather than jumping to the next? With this, the user must click and highlight the contents of the original textbox ... an annoyance and time consuming when entering a lot of data.

When I use SetFocus, nothing happens. The value in the textbox (tab stop 3) is highlighted, not the original.

Hi Leith,

Thank you so much for your support! I added the line CANCEL = True which has stopped the focus jumping to the next textbox.
But the text selection (highlighting) still seems to be failing. If I recall, this may have been a recurring challenge I have had (as mentioned in my initial post). The result I get is simply a blinking cursor after the last character of the defaulted text in the textbox.

Here is my code adapted based on Leith's comments.

Please Login or Register  to view this content.

Is anyone able to suggest a possible solution? Or can I assume I hit a dead end?